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.
Showing posts with label hhmmyy. Show all posts
Showing posts with label hhmmyy. Show all posts
Subscribe to:
Posts (Atom)