I used between operator but it is not working.
If I use >= also it is taking only date into consideration not the time. So if say test_date >='2015-07-24 12:00:00' i am getting all the data from that day instead of filtering from 12:00:00 on 2015-07-24.
Search found 2 matches
- Mon Jul 27, 2015 10:09 pm
- Forum: New to Vertica SQL
- Topic: Calculating difference between two timestamps
- Replies: 4
- Views: 21484
- Mon Jul 27, 2015 9:17 pm
- Forum: New to Vertica SQL
- Topic: Calculating difference between two timestamps
- Replies: 4
- Views: 21484
Calculating difference between two timestamps
Hello, I have a column in my database test data and which is defined as timestamp. For Ex the data in that column is saved as 2015-07-24 12:21:00 I need to extract all the data from that table where the Test data is between 2015-07-24 12:00:00 and 2015-07-24 13:00:00 I need to see all the data that ...