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

SqlServer: Date conversion

Status
Not open for further replies.
rpet

rpet

Programmer
Jun 5, 2000
87
0
0
DE
hi!<br><br>in my source table the date is stored in the char(8) format (yyyymmdd). i want to transfer this data to a target table of type &quot;datetime&quot;. can someone tell me how do perform this conversion? thank you.<br><br>-- ralf<br><br><br>
 
Sort by date Sort by votes
CAST or CONVERT are your function options.&nbsp;&nbsp;Both have a range of options (especially Convert), your best bet is to check the BOL (books on line) <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

jchewsmith
  • Locked
  • Question
Update Query with a MAX(Date) subquery 1
Replies
1
Views
67
JarlH
JarlH
swhiteside
  • Locked
  • Question
Max Date By Training code - Crystal XI
Replies
3
Views
67
PHV
PHV
soushi01
  • Locked
  • Question
Retrieve duplicate records by date time 2
Replies
3
Views
46
soushi01
soushi01
JustATheory
  • Locked
  • Question
Convert Date of Birth to Age, results a negative number
Replies
5
Views
69
JustATheory
JustATheory
Almie
  • Locked
  • Question
Find overlaping dates for one specific Code
Replies
2
Views
48
Almie
Almie

Part and Inventory Search

Sponsor

Back
Top