Search found 2 matches

by manialluri
Mon Jul 27, 2015 10:09 pm
Forum: New to Vertica SQL
Topic: Calculating difference between two timestamps
Replies: 4
Views: 21484

Re: Calculating difference between two timestamps

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.
by manialluri
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 ...

Go to advanced search