CURRENT_TIME - TIME '00:00:00' hour to second giving wrong output

General
Enthusiast

CURRENT_TIME - TIME '00:00:00' hour to second giving wrong output

Hi

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

1 REPLY
Junior Contributor

Re: CURRENT_TIME - TIME '00:00:00' hour to second giving wrong output

This is probably due to some implicit time zone conversion.

Try (CURRENT_TIME AT 0) - TIME '00:00:00+00:00')

Dieter