Aug 18, 2012 at 05:42 PM
select REPLACE(REPLACE(REPLACE(replace (convert(varchar(30), GETDATE(),121), '-', ''), ' ', ''), ':', ''), '.', '')
Aug 18, 2012 at 06:38 PM
Aug 18, 2012 at 06:39 PM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Aug 18, 2012 at 05:42 PM
Seen: 490 times
Last Updated: Aug 18, 2012 at 06:39 PM
How to get last year date same as getdate?
How to convert datetime to only time
Need to find the most recent date based off the most recent time
How To Convert UTC or GST to Local Time
error Conversion failed when converting date and/or time from character string.
using the date data type in SQL Server 2008
Forward slash in character string
Can you convert datetime to nvarchar inside a case stmt so that you can use sum?
Between Date and Time where date and time are in 2 seperate fields