On Tue, Dec 24, 2013 at 12:02 PM, bruce buchanan
<[email protected]> wrote:
> so, let me ask: what do I do when I have all my dates/times in unix millis
> and I want to treat/parse them as dates, datetimes, etc? ie I want to do
Something like
CREATE ALIAS MILLIS_TO_DATE AS $$
java.util.Date millisToDate(long millis) {
return new java.util.Date(millis);
}
$$;
SELECT MILLIS_TO_DATE(yourCol1) FROM yourTable1
Should work.
Note that from the next version we will support syntax like this:
SELECT MILLIS_TO_DATE(1384176929520L)
But unless you're running a nightly build, that won't work right now.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
