2014/09/04 08:40 -0700, Jan Steinman
From: Ed Mierzwa (emierzwa) emier...@micron.com
FROM_UNIXTIME(1409304102.153) /*your epoch column here*/
I don't think the OP has a Unix timestamp.
The number looks suspeciously like concatenation of date digits, 140930 at
the beginning looks like
From: Jan Steinman j...@ecoreality.org
To: mysql@lists.mysql.com
Sent: Thursday, 4 September 2014, 16:40
Subject: RE: converting numeric to date-time?
From: Ed Mierzwa (emierzwa) emier...@micron.com
FROM_UNIXTIME(1409304102.153)/*your epoch column here*/
I don't think the OP has
- Original Message -
From: Jan Steinman j...@ecoreality.org
Subject: RE: converting numeric to date-time?
I don't think the OP has a Unix timestamp.
OP explicitly says epoch including milliseconds - so it's going to be three
digits too long :-)
divide by 1000; split off decimal
From: Ed Mierzwa (emierzwa) emier...@micron.com
FROM_UNIXTIME(1409304102.153) /*your epoch column here*/
I don't think the OP has a Unix timestamp.
The number looks suspeciously like concatenation of date digits, 140930 at
the beginning looks like September 30, 2014.
If that's the case,
: MYSQL General List
Subject: Re: converting numeric to date-time?
* Rajeev Prasad rp.ne...@yahoo.com [2014-09-01 17:55]:
I have a column in a table which is epoch time including milliseconds.
e.g. = 1409304102153
now i want to display all fields in the table but this field as: 2014-8-29
* Rajeev Prasad rp.ne...@yahoo.com [2014-09-01 17:55]:
I have a column in a table which is epoch time including milliseconds.
e.g. = 1409304102153
now i want to display all fields in the table but this field as: 2014-8-29
Fri 09:21:42: GMT (whatever comes in )
and i am