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!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Format date

Status
Not open for further replies.
Learnerprog

Learnerprog

Programmer
Apr 21, 2004
52
US
Hello all,
How to format a date in CYYMMDD in SQL 2000? i.e '09/30/2004'

Thanks in advance
 
Sort by date Sort by votes
in SQL 2000
You're in an MS Access forum.
You may have more accurate replies ina SQL Server forum.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

monkeysee
  • Locked
  • Question
Max Date Qry 1
Replies
3
Views
928
Andrzejek
Andrzejek
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
666
mikrom
mikrom
datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
847
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Get Yesterday's Date
Replies
1
Views
571
caykamanj1966
caykamanj1966
JayRo71
  • Locked
  • Question
Unable to sort date field
Replies
4
Views
496
JayRo71
JayRo71

Part and Inventory Search

Sponsor

Back
Top