tz_bytes.sql 558 B

1234567891011
  1. /* postgres can not */
  2. /* syntax version 1 */
  3. select ToBytes(TzDate32("1901-01-01,Europe/Moscow"));
  4. select cast(FromBytes(ToBytes(TzDate32("1901-01-01,Europe/Moscow")),TzDate32) as string);
  5. select ToBytes(TzDatetime64("1901-01-01T01:02:03,Europe/Moscow"));
  6. select cast(FromBytes(ToBytes(TzDatetime64("1901-01-01T01:02:03,Europe/Moscow")),TzDatetime64) as string);
  7. select ToBytes(TzTimestamp64("1901-01-01T01:02:03.456789,Europe/Moscow"));
  8. select cast(FromBytes(ToBytes(TzTimestamp64("1901-01-01T01:02:03.456789,Europe/Moscow")),TzTimestamp64) as string);