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: 430 times
Last Updated: Aug 18 '12 at 06:39 PM
How to get number of months
string to datetime
Aggregate datetime from 15-minute increments to single hour
which one is better? whether to store date as date or int?
SQL time comparison query?
,How to convert datetime to UTC datetime?
How To Round A Date Column To The Nearest Day
Substring and adding dates
Please help: How to report next 6 months' rent
Update datetime by one year on sql database