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: 505 times
Last Updated: Aug 18, 2012 at 06:39 PM
Storage of DATETIME column
Convert 6092013 to date datatype
convert datetime from varchar error
First day of the week as Monday
Is it possible to insert a datetime/timestamp column on a replicated table?
Convert varchar to Datetime
convert datetime error
Comparing Dates for an Inventory and Sales Report