I am trying below SQL:
SEL CURRENT_TIME, ((CURRENT_TIME - time '00:00:00') hour to second(0)) ;
Output is : 09:23:56 | 8:23:56
Doubt is why the second column is having one hour less ?
Please explain .
Thanks in advance.
*I am using TD13.10
This is probably due to some implicit time zone conversion.
Try (CURRENT_TIME AT 0) - TIME '00:00:00+00:00')