CODEWITHSUNDEEP
databasegrailsgroovytimestamp
Mahi29
Mahi29

Reputation: 94

Database time conversion in Groovy

I'm getting oracle.sql.TIMESTAMPTZ@c9a2424 kinda value when I'm trying to to get the timestamp from Oracle to my Groovy. I tried stringValue(), but didn't help me I got "String Convertion Failed" any help

Upvotes: 0

Views: 302

Answers (1)

Michal_Szulc
Michal_Szulc

Reputation: 4177

Try dateValue:

Calls toDate to convert internal Oracle TIMESTAMPTZ to a Java Date.

or timeValue:

Calls toTime to convert internal Oracle Date to a Java Time.

or timestampValue:

Calls toTimestamp to convert internal Oracle Date to a Java Timestamp.

or checkout other possibilities from Method Summary on that site.

Upvotes: 2

Related Questions