Home Explore Help
Sign In
SMusatov
/
ydb
mirror of https://github.com/ydb-platform/ydb.git
1
0
Fork 0
Files
Tree: 686cf76645
Branches Tags
ydb
/
yql
/
essentials
/
tests
/
sql
/
suites
/
datetime
/
date_diff_compare.sql

date_diff_compare.sql 1.2 KB
History Raw

123456789101112131415161718192021222324 
  1. /* postgres can not */
    2. 

  2. select Date("2001-01-01") == Datetime("2001-01-01T00:00:00Z");
    3. 

  3. select Date("2001-01-01") == Timestamp("2001-01-01T00:00:00Z");
    4. 

  4. select Datetime("2001-01-01T00:00:00Z") == Timestamp("2001-01-01T00:00:00Z");
    5. 

  5. 

  6. select Date("2001-01-01") != Datetime("2001-01-01T00:00:00Z");
    7. 

  7. select Date("2001-01-01") != Timestamp("2001-01-01T00:00:00Z");
    8. 

  8. select Datetime("2001-01-01T00:00:00Z") != Timestamp("2001-01-01T00:00:00Z");
    9. 

  9. 

  10. select Date("2001-01-01") < Datetime("2001-01-01T00:00:00Z");
    11. 

  11. select Date("2001-01-01") < Timestamp("2001-01-01T00:00:00Z");
    12. 

  12. select Datetime("2001-01-01T00:00:00Z") < Timestamp("2001-01-01T00:00:00Z");
    13. 

  13. 

  14. select Date("2001-01-01") <= Datetime("2001-01-01T00:00:00Z");
    15. 

  15. select Date("2001-01-01") <= Timestamp("2001-01-01T00:00:00Z");
    16. 

  16. select Datetime("2001-01-01T00:00:00Z") <= Timestamp("2001-01-01T00:00:00Z");
    17. 

  17. 

  18. select Date("2001-01-01") > Datetime("2001-01-01T00:00:00Z");
    19. 

  19. select Date("2001-01-01") > Timestamp("2001-01-01T00:00:00Z");
    20. 

  20. select Datetime("2001-01-01T00:00:00Z") > Timestamp("2001-01-01T00:00:00Z");
    21. 

  21. 

  22. select Date("2001-01-01") >= Datetime("2001-01-01T00:00:00Z");
    23. 

  23. select Date("2001-01-01") >= Timestamp("2001-01-01T00:00:00Z");
    24. 

  24. select Datetime("2001-01-01T00:00:00Z") >= Timestamp("2001-01-01T00:00:00Z");
    25.