[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] need help in date conversion
From:       venkat karri <venkat9383 () gmail ! com>
Date:       2009-01-30 4:01:09
Message-ID: 265032e50901292001t1e57b3e4h42f3903e1c677700 () mail ! gmail ! com
[Download RAW message or body]

Thanks  dude, that works !!!!!!!!!!!!!

On 1/29/09, Igor Tandetnik <itandetnik@mvps.org> wrote:
> 
> "venkat karri" <venkat9383@gmail.com>
> wrote in message
> news:265032e50901291849h68ff004ay642ba7357a7014b2@mail.gmail.com<news%3A265032e50901291849h68ff004ay642ba7357a7014b2@mail.gmail.com>
> 
> > 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.
> 
> select strftime('%m/%d/%Y', 1125426109, 'unixepoch');
> 
> Igor Tandetnik
> 
> 
> 
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
_______________________________________________
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]