date_convert.sql 1.3 KB

123456789101112131415161718192021222324
  1. /* postgres can not */
  2. select Yql::Convert(Yql::Date(AsAtom("1")),AsAtom("Uint8"));
  3. select Yql::Convert(Yql::Date(AsAtom("1")),AsAtom("Uint32"));
  4. select Yql::Convert(Yql::Date(AsAtom("1")),AsAtom("Int32"));
  5. select Yql::Convert(Yql::Date(AsAtom("1")),AsAtom("Uint64"));
  6. select Yql::Convert(Yql::Date(AsAtom("1")),AsAtom("Int64"));
  7. select Yql::Convert(Yql::Datetime(AsAtom("1")),AsAtom("Uint8"));
  8. select Yql::Convert(Yql::Datetime(AsAtom("1")),AsAtom("Uint32"));
  9. select Yql::Convert(Yql::Datetime(AsAtom("1")),AsAtom("Int32"));
  10. select Yql::Convert(Yql::Datetime(AsAtom("1")),AsAtom("Uint64"));
  11. select Yql::Convert(Yql::Datetime(AsAtom("1")),AsAtom("Int64"));
  12. select Yql::Convert(Yql::Timestamp(AsAtom("1")),AsAtom("Uint8"));
  13. select Yql::Convert(Yql::Timestamp(AsAtom("1")),AsAtom("Uint32"));
  14. select Yql::Convert(Yql::Timestamp(AsAtom("1")),AsAtom("Int32"));
  15. select Yql::Convert(Yql::Timestamp(AsAtom("1")),AsAtom("Uint64"));
  16. select Yql::Convert(Yql::Timestamp(AsAtom("1")),AsAtom("Int64"));
  17. select Yql::Convert(Yql::Interval(AsAtom("1")),AsAtom("Uint8"));
  18. select Yql::Convert(Yql::Interval(AsAtom("1")),AsAtom("Uint32"));
  19. select Yql::Convert(Yql::Interval(AsAtom("1")),AsAtom("Int32"));
  20. select Yql::Convert(Yql::Interval(AsAtom("1")),AsAtom("Uint64"));
  21. select Yql::Convert(Yql::Interval(AsAtom("1")),AsAtom("Int64"));