2014/09/04 08:40 -0700, Jan Steinman
> From: "Ed Mierzwa (emierzwa)"
>
>
> 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 Septem
- Original Message -
> From: "Jan Steinman"
> 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
> From: Jan Steinman
>To: mysql@lists.mysql.com
>Sent: Thursday, 4 September 2014, 16:40
>Subject: RE: converting numeric to date-time?
>
>
>> From: "Ed Mierzwa (emierzwa)"
>>
>>
>> FROM_UNIXTIME(1409304102.153)/*your epoch column
> From: "Ed Mierzwa (emierzwa)"
>
>
> 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, you need to
mber 01, 2014 5:51 PM
To: Rajeev Prasad
Cc: MYSQL General List
Subject: Re: converting numeric to date-time?
* Rajeev Prasad [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
* Rajeev Prasad [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 not findi
