Learnerprog
Programmer
Hello All,
How to format a date in CYYMMDD in SQL 2000? i.e '09/30/2004'
Thanks, Joe
How to format a date in CYYMMDD in SQL 2000? i.e '09/30/2004'
Thanks, Joe
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date Format
- Thread starter Learnerprog
- Start date
- Status
Code:
select convert(char(10),getdate(),112)------------------------------------------------------------------------------------------------------------------------
If you don't have a sense of humor, you probably don't have any sense at all.
- Anonymous
- Status
Similar threads
- Locked
- Question
- Locked
- Question