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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date Question
- Thread starter jfield817
- Start date
select * from MyTable where MyDate = '12/31/2000'
This may be affected by your date setting, but I believe SQL Server is pretty forgiving about date literals. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href= - Visual FoxPro Development</a><br> [/sig]
This may be affected by your date setting, but I believe SQL Server is pretty forgiving about date literals. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href= - Visual FoxPro Development</a><br> [/sig]
I often use "31-Dec-2000" format for program variables to make sure that it is unaffected by the server's date format. [sig]<p> <br><a href=mailto: > </a><br><a href= home</a><br> [/sig]
- Status
Similar threads
- Locked
- Question