How to convert dd/MM/YYYY to yyyyMMdd in sqlserver 2005
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
1 If you use front end application, do formation there
2 Otherwsie, use
select convert(char(8),date_col,112) from your_table
No one has followed this question yet.
SQL time comparison query?
Please help: How to report next 6 months' rent
Month to Date Query update
how to change the date format of sqlserver 2005
conversion of char data type to a datetime data type resulted in out-of-range