I had not realized that ALIAS could be used in that way, thank you so
much for the tip - you've made my week.
On Fri, Sep 19, 2008 at 10:43 AM, Thomas Mueller
<[EMAIL PROTECTED]> wrote:
>
> Hi,
>
>> get the long value of a TIMESTAMP column?
>
> In Java it's simple. What about writing a Java method:
>
> public class Test {
> public static long getTimeMillis(java.sql.Timestamp ts) {
> return ts.getTime();
> }
> }
> CREATE ALIAS TIME_MILLIS FOR "Test.getTimeMillis";
> SELECT TIME_MILLIS(NOW());
>
>> adding EPOCH to the time functions
>
> For negative year values? Unlike other databases, H2 support negative
> year values:
> CALL YEAR(TIMESTAMP '-100-01-01 10:00:00');
>> -100
>
> Regards,
> Thomas
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
