unixtime update syntax

2003-12-02 Thread Ron McKeever
Anyone have a response to the following: Hi 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. I know I can get the data I want with

RE: unixtime update syntax

2003-12-02 Thread Dan Greene
) from t_test; -Original Message- From: Ron McKeever [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 10:58 AM To: [EMAIL PROTECTED] Subject: unixtime update syntax Anyone have a response to the following: Hi I have a db that gets data dumped into it. One

RE: unixtime update syntax

2003-12-02 Thread Ron McKeever
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

Re: unixtime update syntax

2003-12-02 Thread Keith C. Ivey
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

RE: unixtime update syntax

2003-12-02 Thread Ron McKeever
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

RE: unixtime update syntax

2003-12-02 Thread Keith C. Ivey
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,

Re: unixtime update syntax

2003-12-02 Thread Michael Stassen
, 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

unixtime update syntax

2003-12-01 Thread Ron McKeever
Hi 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. I know I can get the data I want with php or mysql to convert it, but I need