Hibernate Community • View topic - Need to Insert SYSTIMESTAMP in a Timestamp field.

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Need to Insert SYSTIMESTAMP in a Timestamp field.

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

jatinfrost

Post subject: Need to Insert SYSTIMESTAMP in a Timestamp field.

Posted: Thu Apr 17, 2008 6:32 pm

Newbie

Joined: Thu Apr 17, 2008 6:28 pm
Posts: 6

Hi All,

I need to populate a TimeStamp field with SYSTIMESTAMP. Do let me the know the best possible way. Is it possible thru mapping file.

eg.,

<property name="createTimestamp" type="timestamp" formula="(SELECT TO_DATE(SYSTIMESTAMP,'YYYY:MM:DD-HH24:MI:SS:FF4') FROM DUAL)" />

Top

testos123

Post subject:

Posted: Thu Apr 17, 2008 9:56 pm

Newbie

Joined: Wed Apr 16, 2008 7:49 pm
Posts: 10

Formula columns used only for selects. It won't be used for inserts. You'll have to provide the value from java code or have the value populated with a trigger,

hth,
Sivec

Top

jatinfrost

Post subject:

Posted: Fri Apr 18, 2008 9:29 am

Newbie

Joined: Thu Apr 17, 2008 6:28 pm
Posts: 6

Thanks for help.
I ll try that.....

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum