Tag: sql

mssql format date fields

– Microsoft SQL Server T-SQL date and datetime formats – Date time formats – mssql datetime – MSSQL getdate returns current system date and time in standard internal format SELECT convert(varchar, getdate(), 100) – mon dd yyyy hh:mmAM (or PM) – Oct 2 2008 11:01AM SELECT convert(varchar, getdate(), 101) – mm/dd/yyyy – 10/02/2008 SELECT convert(varchar,…


Get every new post on this blog delivered to your Inbox.

Join other followers: