Aug 18 '12 at 05:42 PM
select REPLACE(REPLACE(REPLACE(replace (convert(varchar(30), GETDATE(),121), '-', ''), ' ', ''), ':', ''), '.', '')
Aug 18 '12 at 06:38 PM
Aug 18 '12 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 '12 at 05:42 PM
Seen: 363 times
Last Updated: Aug 18 '12 at 06:39 PM
Group by minute
Nvarchar conversion changing datetime from style 120 to 109
conversion of char data type to a datetime data type resulted in out-of-range
Is there a way to add a date and time together to get the datetime value in SQL?
Dateadd function & CURRENT_TIMESTAMP
Character to Date Conversion keeps failing???
Month to Date Query update
epoch datetime conversion