Re: conver Date to long
From: Jim Kennedy <kennedy-family_at_home.com>
Date: Wed, 14 Nov 2001 05:35:27 GMT
Message-ID: <zonI7.24196$XJ4.15020859_at_news1.sttln1.wa.home.com>
Date: Wed, 14 Nov 2001 05:35:27 GMT
Message-ID: <zonI7.24196$XJ4.15020859_at_news1.sttln1.wa.home.com>
Do you want a Julian representation of a date? I hope so otherwise date to
long makes no sense.
Jim
select to_char(my_date,'J') from tbl;
"zuth" <tzhong_at_163.net> wrote in message
news:c8c3eca3.0111131915.412b87a_at_posting.google.com...
> How to conver Date to long?
>
> I use 'select my_date from tbl;', it reply such as'11-Nov-01'.
> However, I want it reply long, like '12345678901...'
>
> And, if I use JDBC, how can I get the long from Date? I searched Class
> Java.sql.Date but can not find the proper answer.
>
> thanks,
> tz
Received on Wed Nov 14 2001 - 06:35:27 CET