Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 To get the time in hhmmss format

Author  Topic 

Rajeswari
Starting Member

20 Posts

Posted - 2001-11-22 : 06:18:40
Similar in Visual basic, there is any keyword like FORMAT. I need this because for scheduling, to provide the active start date and start time, i have to do many CAST and CONVERT to get the formats like yyyymmdd or hhmmss. It becomes terrible when hour or minute is in single digit.
   

- Advertisement -