Manning's Countdown to 2014
. Use discount code crdotd14 all month for 50% off every deal.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Date function in Ingres DB
Joined: Feb 23, 2004
Aug 18, 2004 04:54:00
How do i do i check in my where clause if:
a date_field in a table is less that 3 past months from today.
Note: I am using INGRES DATABASE
select * from tablename
date_field is less that 3 months from today.
[ August 18, 2004: Message edited by: Bear Bibeault ]
Joined: Aug 02, 2004
Aug 18, 2004 08:29:00
It's a long time since I've used Ingres (6 or 7 years!), but if memory serves you can do it with something mad like:
where date_field < 'today' - '3 months'
It might be today() without the quotes, however. I'm pretty sure that today - 3 is 3 days ago. Try it.
Anyway, Ingres date stuff is (or was, at least) done using really nasty implicit conversion from strings. It makes the code read OK though.
Hope this helps.
Did you see how Paul
cut 87% off of his electric heat bill with 82 watts of micro heaters
subject: Date function in Ingres DB
Problem of JDBC request is not supported
accessing database ingres 6.4
jdbc driver loading
HQL date without time
finding the closest time in database record
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013