The time zone matters... your results are exactly 8 hours off... PST is gmt -8. So it
looks like the from_unixtime function is converting to what the time was locally at
that moment in GMT. Not what I would have expected either
What do you get when you run-
select unix_timestamp(urtime)
sec)
Any ideas?
Ron
-Original Message-
From: Dan Greene [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 8:30 AM
To: Ron McKeever; [EMAIL PROTECTED]
Subject: RE: unixtime update syntax
The time zone matters... your results are exactly 8 hours off... PST is
gmt -8. So it looks
On 2 Dec 2003 at 7:57, Ron McKeever wrote:
I have a db that gets data dumped into it. One of the columns gets
unix timestamp data utime. I what to covert that into a datetime
column so I can utlize indexes and such. But I still what the unixtime
to remain.
You can use indexes with a Unix
Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 8:55 AM
To: [EMAIL PROTECTED]
Subject: Re: unixtime update syntax
On 2 Dec 2003 at 7:57, Ron McKeever wrote:
I have a db that gets data dumped into it. One of the columns gets
unix timestamp data utime. I
On 2 Dec 2003 at 9:12, Ron McKeever wrote:
Thats seems like a bug to me.
I would think FROM_UNIXTIME would take a unixtime stamp
and covert it to what it is. We know its from GMT
A Unix timestamp represents a particular second in time. It doesn't
have a time zone associated with it. Yes,
, December 02, 2003 8:55 AM
To: [EMAIL PROTECTED]
Subject: Re: unixtime update syntax
On 2 Dec 2003 at 7:57, Ron McKeever wrote:
I have a db that gets data dumped into it. One of the columns gets
unix timestamp data utime. I what to covert that into a datetime
column so I can utlize indexes