Re: SQuirreL SQL client time zone problem
Posted: Thu Jul 12, 2012 10:25 am
The 'TYPE_NAME' is 'Time'. The 'DATA_TYPE' = '92'.
I ran a few queries:
select full_time at timezone 'CET' test from kdwh3.time_dimension where time_dimension_id = 1
output:
test
02:00:00
select full_time at timezone 'UTC' test from kdwh3.time_dimension where time_dimension_id = 1
output:
test
22:00:00
select * from kdwh3.time_dimension where full_time at timezone 'CET' = '01:00:00'
output:
time_dimension_id full_time hour minute second
3601 02:00:00 1 0 0
select * from kdwh3.time_dimension where full_time at timezone 'UTC = '01:00:00'
output:
time_dimension_id full_time hour minute second
blank
I ran a few queries:
select full_time at timezone 'CET' test from kdwh3.time_dimension where time_dimension_id = 1
output:
test
02:00:00
select full_time at timezone 'UTC' test from kdwh3.time_dimension where time_dimension_id = 1
output:
test
22:00:00
select * from kdwh3.time_dimension where full_time at timezone 'CET' = '01:00:00'
output:
time_dimension_id full_time hour minute second
3601 02:00:00 1 0 0
select * from kdwh3.time_dimension where full_time at timezone 'UTC = '01:00:00'
output:
time_dimension_id full_time hour minute second
blank