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

how to covert strint to datetime

Status
Not open for further replies.
9654

9654

Programmer
Aug 4, 2003
34
US
i am trying to convert a a string to datetime and i am having issues. has anybody faced this before?
 
Sort by date Sort by votes
What is the string? Easiest way is

select convert(datetime, "1 jan 2004")

Greg.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AM_WG
  • Locked
  • Question
Need help with SQL query to update a Micros report
Replies
0
Views
158
AM_WG
AM_WG
raphael75
  • Locked
  • Question
trying to call Sybase stored procedure with parameters from PHP
Replies
0
Views
112
raphael75
raphael75
baltman
  • Locked
  • Question
Precison too large error via Excel/ODBC solution needed
Replies
0
Views
116
baltman
baltman
vzavec
  • Locked
  • Question
PowerBuilder to SpatiaLite
Replies
0
Views
96
vzavec
vzavec
sux2b
  • Locked
  • Question
How to find the version of the database
Replies
1
Views
84
mrdenny
mrdenny

Part and Inventory Search

Sponsor

Back
Top