Filter with timestamp and postgresql #541
-
How can I find all record created after How to solve it and |
Beta Was this translation helpful? Give feedback.
Replies: 12 comments 15 replies
-
This is a defect. Will be create an issue and resolve it and you should get it as part of release 0.3.3 soon. |
Beta Was this translation helpful? Give feedback.
-
` insert into tbl_employees (full_name, created_at) values ('John Travolta', '2005-01-01'); insert into tbl_employees (full_name, created_at) values ('Al Pacino', '2006-05-20'); ` |
Beta Was this translation helpful? Give feedback.
-
|
Beta Was this translation helpful? Give feedback.
-
Note that at this time only ISO date and date time formats are supported. |
Beta Was this translation helpful? Give feedback.
-
` insert into tbl_depts (dept_name, created_at) values ('Actor', '2016-06-20 19:11:31'); insert into tbl_depts (dept_name, created_at) values ('Director', '2018-06-21 19:10:31'); |
Beta Was this translation helpful? Give feedback.
-
` ` |
Beta Was this translation helpful? Give feedback.
-
` CREATE TABLE joinplay.tbl_student ( insert into tbl_student (full_name, created_at) values ('Issac Newton', '2016-06-22 19:10:25-07'); insert into tbl_student (full_name, created_at) values ('Albert Einstein', '2018-06-22 19:10:25-07'); ` |
Beta Was this translation helpful? Give feedback.
-
` ` |
Beta Was this translation helpful? Give feedback.
-
@khanhpd2002 can you please confirm if the issues have been resolved now? |
Beta Was this translation helpful? Give feedback.
-
I entered another row in the database like this
Then ran a query
|
Beta Was this translation helpful? Give feedback.
-
Thanks @khanhpd2002 |
Beta Was this translation helpful? Give feedback.
-
Turns out to be a postman character encoding issue :D |
Beta Was this translation helpful? Give feedback.
This is a defect. Will be create an issue and resolve it and you should get it as part of release 0.3.3 soon.
@khanhpd2002 - do you mind joining our discord please so that we can assist you better.