date_tz_bitcast.sql 1.4 KB

123456789101112131415161718192021222324252627
  1. /* postgres can not */
  2. select bitcast(Yql::TzDate(AsAtom("1,UTC")) as Uint8);
  3. select bitcast(Yql::TzDate(AsAtom("1,UTC")) as Int8);
  4. select bitcast(Yql::TzDate(AsAtom("1,UTC")) as Uint16);
  5. select bitcast(Yql::TzDate(AsAtom("1,UTC")) as Int16);
  6. select bitcast(Yql::TzDate(AsAtom("1,UTC")) as Uint32);
  7. select bitcast(Yql::TzDate(AsAtom("1,UTC")) as Int32);
  8. select bitcast(Yql::TzDate(AsAtom("1,UTC")) as Uint64);
  9. select bitcast(Yql::TzDate(AsAtom("1,UTC")) as Int64);
  10. select bitcast(Yql::TzDatetime(AsAtom("1,UTC")) as Uint8);
  11. select bitcast(Yql::TzDatetime(AsAtom("1,UTC")) as Int8);
  12. select bitcast(Yql::TzDatetime(AsAtom("1,UTC")) as Uint16);
  13. select bitcast(Yql::TzDatetime(AsAtom("1,UTC")) as Int16);
  14. select bitcast(Yql::TzDatetime(AsAtom("1,UTC")) as Uint32);
  15. select bitcast(Yql::TzDatetime(AsAtom("1,UTC")) as Int32);
  16. select bitcast(Yql::TzDatetime(AsAtom("1,UTC")) as Uint64);
  17. select bitcast(Yql::TzDatetime(AsAtom("1,UTC")) as Int64);
  18. select bitcast(Yql::TzTimestamp(AsAtom("1,UTC")) as Uint8);
  19. select bitcast(Yql::TzTimestamp(AsAtom("1,UTC")) as Int8);
  20. select bitcast(Yql::TzTimestamp(AsAtom("1,UTC")) as Uint16);
  21. select bitcast(Yql::TzTimestamp(AsAtom("1,UTC")) as Int16);
  22. select bitcast(Yql::TzTimestamp(AsAtom("1,UTC")) as Uint32);
  23. select bitcast(Yql::TzTimestamp(AsAtom("1,UTC")) as Int32);
  24. select bitcast(Yql::TzTimestamp(AsAtom("1,UTC")) as Uint64);
  25. select bitcast(Yql::TzTimestamp(AsAtom("1,UTC")) as Int64);