OraFAQ Forum: SQL & PL/SQL » Convert datetime representation

Home » SQL & PL/SQL » SQL & PL/SQL » Convert datetime representation

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Convert datetime representation [message #334446]

Wed, 16 July 2008 09:45

daff24
Messages: 11
Registered: June 2008

Junior Member

Hi!

I have an INSERT-script which is generated from sql server 2005 using MS Database Publishing Wizard.

INSERT INTO table(id, date) VALUES (1, CAST(0xffff059f AS DATETIME))

Is there any way I can convert this datetime-representaion so it could be inserted into Oracle database datetime column? Is there any function for this?

Thank you!

[Updated on: Wed, 16 July 2008 09:56]

Report message to a moderator

[Message index]

		Convert datetime representation By: daff24 on Wed, 16 July 2008 09:45
		Re: Convert datetime representation By: Michel Cadot on Wed, 16 July 2008 10:07
		Re: Convert datetime representation By: daff24 on Wed, 16 July 2008 10:23
		Re: Convert datetime representation By: Michel Cadot on Wed, 16 July 2008 10:28
		Re: Convert datetime representation By: BlackSwan on Wed, 16 July 2008 10:30
		Re: Convert datetime representation By: JRowbottom on Wed, 16 July 2008 10:29
		Re: Convert datetime representation By: daff24 on Wed, 16 July 2008 10:42
		Re: Convert datetime representation By: JRowbottom on Wed, 16 July 2008 11:03
		Re: Convert datetime representation By: Michel Cadot on Wed, 16 July 2008 11:25

Previous Topic:	need help to create index to optimize query
Next Topic:	How many OUT REF CURSOR arguments can be defined in a procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 02:50:36 CDT 2024