A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Arduino in Action
this week in the
A special promo:
Enter your blog post or vote on a blogger to be featured in an upcoming Journal
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 ]
I agree. Here's the link:
- if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
subject: SQL date
how to get yesterdays date using jsp
get column value in a database
current system date using sql date
Why they have named a calendar method like this?
getting current date -applets
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013