A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Joined: Nov 17, 2001
Oct 29, 2002 15:49:00
In SQL, using CURRENT DATE, we can get the current date, for example, '2002-10-29'.
How can we get a date that is 100 days earlier than current date? (using SQL only)
Joined: Jan 29, 2002
Oct 30, 2002 00:05:00
select sysdate-100 from dual;
select current_date-100 from dual;
This works in oracle.
[ October 30, 2002: Message edited by: Les Dsouza ]
It is sorta covered in the
JavaRanch Style Guide
subject: SQL date
get column value in a database
current system date using sql date
getting current date -applets
how to get yesterdays date using jsp
Why they have named a calendar method like this?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013