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