Hi!

Is it possible to convert an int field to datetime?

In one of our Sybase ASE DB there is a field called "time" of type int, and
it contains the
value 1093409123. In the application it looks like this is converted to
25.08.2004 06:45

Or is it so that Sybase cannot do this kind of conversation, so it is the
application who is doing this.

Kjell P.

You are going to have to look at the application and see how it's
converting, number of seconds since 01/01/1970 or ????

"Kjell Pettersen" <kjell (AT) gpsgroup (DOT) cc> wrote

On Wed, 25 Aug 2004 12:46:51 +0200, Kjell Pettersen wrote:

That's most likely a "time_t" value. You can convert this to a datetime
value using the dateadd() function:

1> select dateadd(ss, 1093409123, 'jan 1 1970');

-------------------
Aug 25 2004 4:45AM

As you see this shows 4:45 insted of 6:45 as the time, because Sybase
doesn't understand timezones. The time_t value is in reference to
UTC, and my machine runs in European Summer Time at the moment.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html

"Kjell Pettersen" <kjell (AT) gpsgroup (DOT) cc> wrote

It is quite likely that this int value specifies an offset of <x> days
from some base date like 1/1/1900. You can verify this by taking the
values of some
known dates and using the dateadd() function to subtract <x> days from
the known datetime value - if they all give you the same date, that is
your base date. You can then convert any given int value to a
datetime using dateadd() to add <x> days to that base date.

Cheers,
-bret

"Kjell Pettersen" <kjell (AT) gpsgroup (DOT) cc> wrote

Looking at it a little closer - there is a time component, so
probably not days, but maybe minutes or seconds or milliseconds
or 1/300th seconds - compare a few known values to get a feel for
the size of the unit being used.

Cheers,
-bret