Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
using select query for current date
Name: kalyanbrata.dhar Date: December 31, 2008 at 00:41:34 Pacific OS: SunOS5.9 CPU/Ram: . Product: . / . Subcategory: General
Comment:
Hi,
I trying to use select query to get particular records for current date . This is my query:
select so_module, max (to_char(SO_JOB_STARTED,'HH24:MI')) AS SO_JOB_STARTED from so_job_history where so_module in ( 'job1', 'job2', 'job3' ) and SO_JOB_STARTED= sysdate group by (so_module);
for this query I am getting no errors but the output is also wrong as I am getting 'no rows selected'.
Could anyone help me in using sysdate appropriately.
Summary: Hi, Does anyone know of a UNIX command that will return the current date minus 1 hr? For example, if I the current date command returns "Fri Jan 10 14:08:15 EST 2003", what command would return "Fri J...
Summary: I am trying to subtract 35 days from the current date.. Whatever that date is, needs to be appended to my output filename. The following will subtract days from current date, this calculated date is r...
0 
