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.
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: 527 times
Last Updated: Aug 18, 2012 at 06:39 PM
How can I format my datetime value in a Windows forms application
Date Problem in SQl Server 2005
error Conversion failed when converting date and/or time from character string.
how to create time restriction
Date time in SQL Server
select records between dates in concurrent years
Generation of Table with Working dates and weekends
DateTime to Small Datetime
DateTime and Decimal data types space handling!
Start Date and End date in SQL