Re: [sqlite] Retrieving date

[Derrell . Lipman]

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 some changes in the hours.
>
> How can I retrieve the accurately converted date and time ?

You may want:

  select datetime(sdate, 'unixepoch', 'localtime') from mytab;

Derrell

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Retrieving date

[Markus Hoenicka]

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 mytab;
>
> It shows a formatted date, but there is some changes in the hours.
>
> How can I retrieve the accurately converted date and time ?
>
> Thanks,
>  Lloyd.
>
>
> __
> Scanned and protected by Email scanner
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
>
>


-- 
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Retrieving date

[Lloyd]

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 the accurately converted date and time ?

Thanks,
 Lloyd.


__
Scanned and protected by Email scanner

-
To unsubscribe, send email to [EMAIL PROTECTED]
-