This is my query select END_time from scheduler_history where job_name = 'SMS_Test';
and the result is END_TIME <#> 2014-08-05 08:41:11.0 2014-08-05 10:07:58.0 2014-08-05 10 :13:51.0 but the result should be END_TIME <#>2014-08-05 15:41:11.02014-08-05 17:07:58.02014-08-05 17 :13:51.0 Is it possible to query the time and add 7 hours to result ignoring time in DB? On Tuesday, August 5, 2014 11:26:51 PM UTC+7, Thomas Mueller wrote: > > Hi, > > Sorry, you need to provide some sample code. > > Regards, > Thomas > > > > On Tue, Aug 5, 2014 at 12:28 PM, Phamorn Hongsawat <[email protected]> > wrote: > >> I have a problem with time column. In my table has a column named >> 'End_Time' record from the program. >> >> Unfortunately the program can't change the time zone. So the time >> recorded in this table is slower than real. >> >> How can I add more hour or get the actually time when I use select(). >> >> Thank you for your help. >> >> Phamorn Hongsawat >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
