Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: can you set the epoch for julian date in Oracle?
Ben schreef:
>
> Can anyone see any flaw in that?
>
I won't.
But as dates are effectively numbers, you can add and subtract them. Just add 1-1-1900 to all of your dates, and never make that mistake again: dates belong in a DATE type column
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Thu Feb 15 2007 - 12:58:35 CST