Hi; I'm trying to get a datetime field converted to a
MMDDYY format.
I'm trying to use the
This gives it to me as YYMMDD. I can't seem to find a way to convert it, except to
use the substring command to pull the pieces. Any idea's?
Thanks
Ken
MMDDYY format.
I'm trying to use the
Code:
Convert(varchar(6), Birthdate,12)
use the substring command to pull the pieces. Any idea's?
Thanks
Ken