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

oracle date format to sql server date format

Status
Not open for further replies.
fgeorge

fgeorge

Programmer
Jun 28, 2002
76
NG
how can i convert "20030806 18:00:00" , which is an oracle date format to a format that sql ser ver will accept in a datetime data field?
 
Sort by date Sort by votes
Are you trying to insert date values? If so, that format will work fine.

Code: 
INSERT tbl (date_col) VALUES ('20030806 18:00:00')

--James
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MathiasB
  • Locked
  • Question
Parameterised sql server query
Replies
8
Views
476
Chriss Miller
C
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
796
Volvere
V
leifoet
  • Locked
  • Question
How te filter by date ?
Replies
9
Views
605
dhookom
dhookom
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
616
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
637
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top