CODEWITHSUNDEEP
sqlfunctionhsqldb
chance
chance

Reputation: 6487

HsqlDB 1.8 Date Functions

I am using HsqlDB 1.8 and cannot upgrade to 2.0 for some reasons. Now I need to insert a record including a TimeStamp field, but I cannot find any functions to convert a string to TimeStamp Perhaps it is easy with HsqlDB 2.0, but how can I do with 1.8?

Upvotes: 4

Views: 3836

Answers (1)

fredt
fredt

Reputation: 24372

CAST (string_value AS TIMESTAMP)

For example:

CAST ('2012-09-20 21:30:15.786' AS TIMESTAMP)

Upvotes: 8

Related Questions