[prev in list] [next in list] [prev in thread] [next in thread]
List: sqlite-users
Subject: Re: [sqlite] help: need help in date conversion
From: P Kishor <punk.kish () gmail ! com>
Date: 2009-01-30 4:49:54
Message-ID: cdf6db500901292049h566a223ev1b112c5b65c75b3d () mail ! gmail ! com
[Download RAW message or body]
On 1/29/09, venkat karri <venkat9383@gmail.com> wrote:
> Hi All,
>
> I have a database where date is stored in the integer format ( eg:
> 1125426109) I want the output in mm/dd/yyyy format. can any one tell me the
> syntax to convert the date.
http://www.sqlite.org/lang_datefunc.html
You might do well by spending some time on the sqlite.org website. It
will make your experience with sqlite more pleasant and efficient.
>
> Regards,
>
> Venkata
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
Puneet Kishor http://www.punkish.org/
Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/
Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic