date_tz_bytes.sql 539 B

12345678910
  1. /* postgres can not */
  2. /* syntax version 1 */
  3. select ToBytes(TzDate("2001-01-01,Europe/Moscow"));
  4. select cast(FromBytes(ToBytes(TzDate("2001-01-01,Europe/Moscow")),TzDate) as string);
  5. select ToBytes(TzDatetime("2001-01-01T01:02:03,Europe/Moscow"));
  6. select cast(FromBytes(ToBytes(TzDatetime("2001-01-01T01:02:03,Europe/Moscow")),TzDatetime) as string);
  7. select ToBytes(TzTimestamp("2001-01-01T01:02:03.456789,Europe/Moscow"));
  8. select cast(FromBytes(ToBytes(TzTimestamp("2001-01-01T01:02:03.456789,Europe/Moscow")),TzTimestamp) as string);