dynamobi/dynamobi — Issue #697: [FRG-175] casting current_timestamp or localtimestamp into a varchar give a value that is 1 hour ahead
Author: dynamobi-build
Created: 2011-12-30 03:43:45+00:00
State: open
Labels: FRG

[reporter="elin", created="Fri, 28 Jul 2006 18:47:41 -0500 (GMT-05:00)"]
To repro:

values current_timestamp;

values cast (current_timestamp as varchar(25));

values localtimestamp;

values cast (localtimestamp as varchar(25));

********************

example log:

0: jdbc:luciddb:> values current_timestamp;

+--------------------------+

| CURRENT_TIMESTAMP |

+--------------------------+

| 2006-07-29 01:51:56.665 |

+--------------------------+

1 row selected (0.133 seconds)

0: jdbc:luciddb:> values cast (current_timestamp as varchar(25));

+----------------------+

|EXPR$0|

+----------------------+

| 2006-07-29 02:51:56 |

+----------------------+

1 row selected (0.125 seconds)