Correct SQL Format for Date Duration Selects
2001-12-13 01:03:59
Subject: |
Correct SQL Format for Date Duration Selects |
From: |
"Seay, Paul" <seay_pd AT NAPTHEON DOT COM> |
Date: |
Thu, 13 Dec 2001 01:00:42 -0500 |
This is not a valid SQL statement based on my knowledge of SQL. The reason
is DAYS is an INTEGER DECIMAL(15,0). Cannot use a floating to achieve what
you are trying to do.
The actual way to do this is:
where (backup_end <current_timestamp - 1 hours)
There are all kinds of modifiers that you can use on the integers to make
them work in date duration calculations. These are standard SQL
capabilites.
|
<Prev in Thread] |
Current Thread |
[Next in Thread> |
- Correct SQL Format for Date Duration Selects,
Seay, Paul <=
|
|
|