Date

[elsie]

Pls help me with the syntax to convert an int to mmyy
eg 1299
to 12/99
thanks

[tim wilkinson]

I take it it's a string you're after, not a datetime type:

substring(convert(char(4),1299),1,2)+'/'+right(convert(char(4),1299),2)

substring(convert(char(4),@the_int),1,2)+'/'+right(convert(char(4),@the_int),2)

------------
elsie at 6/29/00 2:16:51 PM

Pls help me with the syntax to convert an int to mmyy
eg 1299
to 12/99
thanks