Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

MS SQL Server date format

3 Posts 2 Posters 0 Views 1 Watching

S Offline
S Offline
spn

wrote on last edited by

#1

Does MS SQL Server support dates in 'mmyy' format? If so, how??
M 1 Reply Last reply

0
S spn

Does MS SQL Server support dates in 'mmyy' format? If so, how??
M Offline
M Offline
michanne

wrote on last edited by

#2

Left(Convert(char(6),getdate(),12),4) michanne
S 1 Reply Last reply

0
M michanne

Left(Convert(char(6),getdate(),12),4) michanne
S Offline
S Offline
spn

wrote on last edited by

#3

Thanks... But i want the data to retain datetime datatype, so that i can apply datetime functions to the data.
1 Reply Last reply

0

Log in to reply