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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date format

Status
Not open for further replies.
camy123

camy123

Programmer
Mar 5, 2004
171
GB
hi guys does ne one know how to select all the rows from a table where the date is in the correct format dd/mm/yy else dont bring these results out.
 
Sort by date Sort by votes
Look at ISDATE in BOL.

-SQLBill

BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine

Posting advice: FAQ481-4875
 
Upvote 0 Downvote
how would i update all dates for example that are
mm/yyyy to yyyy/mm
and
 
Upvote 0 Downvote
For all readers,

Camy123 started a new thread concerning the last post (about updating all dates from mm/yyyy to yyyy/mm). To respond to that question, go to THREAD183_984706.

Thank you.

-SQLBill

Posting advice: FAQ481-4875
 
Upvote 0 Downvote
Oopps, that should have been THREAD183-984706.

Sorry.

-SQLBill

Posting advice: FAQ481-4875
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
How te filter by date ?
Replies
9
Views
619
dhookom
dhookom
peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
643
Andrzejek
Andrzejek
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
634
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Last date per userid 1
Replies
3
Views
326
Andrzejek
Andrzejek
niall5098
  • Locked
  • Question
Create plan guide with date time parameters
Replies
3
Views
376
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top