Home Forums Programming General View Complete Timestamp in VB RE: View Complete Timestamp in VB
SQLBill
SSC Guru
Points: 51440
More actions
August 4, 2003 at 10:50 am
#468467
How about the SQL Server command CONVERT:
SELECT CONVERT(VARCHAR(23), GETDATE(), 121)
That will return the date and time in the format you want. yyyy-mm-dd hh:mi:ss.mmm
-SQLBill