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

List:       sqlite-users
Subject:    Re: [sqlite] Convert the CURRENT_TIMESTAMP
From:       Chris Wedgwood <cw () f00f ! org>
Date:       2008-07-29 22:34:20
Message-ID: 20080729223420.GA7072 () puku ! stupidest ! org
[Download RAW message or body]

On Tue, Jul 29, 2008 at 02:03:01PM -0700, Joanne Pham wrote:

> I still have the problem to set the result of the below statement to
> variable so I can print out mulitple times without the executing the
> select statement over and over again.

create a view?

> select '#device local time = ' ||
> (case strftime('%w', d) when '0' then 'SUN' when '1' then 'MON' when '2' then 'TUE' \
> when '3' then 'WED' when '4' then 'THUR' when '5' then 'FRI' when '6' then 'SAT' \
> end)  || ' ' || (case strftime('%m', d) when '01' then 'JAN'  when '02' then 'FEB' \
> when '03' then 'MAR' when '04' then 'APR' when '05' then 'MAY' when '06' then 'JUN' \
> when '07' then 'JUL'  when '08' then 'AUG' when '09' then 'SEP' when '10' then \
> 'OCT' when '11' then 'NOV'  when '12' then 'DEC' end) || ' ' || strftime('%d \
> %H:%M:%S %Y', d,'localtime') || ', '  from (select CURRENT_TIMESTAMP as d)   ;

this seems like a really painful thing to do in sql when the calling
language almost certainly has far easier ways to do this (and you
could make the sql simpler too probably)
_______________________________________________
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]