Lloyd <[EMAIL PROTECTED]> writes:
> Hi,
> I stored a unix epoch (32 bit integer) date in the sqlite data base. I
> want to retrieve it in the readable date format. For that I use the
> following query
>
> select datetime(sdate,'unixepoch') from mytab;
>
> It shows a formatted date, but there is
UCT vs. local time, perchance?
Markus
Lloyd <[EMAIL PROTECTED]> was heard to say:
> Hi,
> I stored a unix epoch (32 bit integer) date in the sqlite data base. I
> want to retrieve it in the readable date format. For that I use the
> following query
>
> select datetime(sdate,'unixepoch') from m
Hi,
I stored a unix epoch (32 bit integer) date in the sqlite data base. I
want to retrieve it in the readable date format. For that I use the
following query
select datetime(sdate,'unixepoch') from mytab;
It shows a formatted date, but there is some changes in the hours.
How can I retrieve th
3 matches
Mail list logo