Is there a way of converting a datetime data type in the form [DD/MM/YYYY HH:MM:SS] to an integer containing just the time in the form [HHMMSS].SELECT REPLACE((CONVERT(VARCHAR,GETDATE(),24)),':','')
This converts it to a varchar. You actually don't want to convert it to integer as it will drop off the leading zeros.
No comments:
Post a Comment