Re: conver Date to long

Thanks. I tried but it only return 7 digits, like '2452227'. However, I want the long, like '1003441232000'.

tz

"Jim Kennedy" <kennedy-family_at_home.com> wrote in message news:<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.
> select to_char(my_date,'J') from tbl;
>
> Jim
> "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 - 16:11:01 CET