ADSM-L

Help on Sql Date

2001-12-30 01:46:52
Subject: Help on Sql Date
From: Robert Ouzen <rouzen AT UNIV.HAIFA.AC DOT IL>
Date: Sun, 30 Dec 2001 08:41:45 +0200
Hi
I want to run this Select command  the next day   but didn't know the
correct syntax   for where date(start_time)= ??????  To get the correct
output for the day before. (like date(start_time)=date(current date) -1).

'select entity as node_name, date(start_time) as date, cast(activity as
varchar(10))as activity, time(start_time) as start, time(end_time) as
end,cast(bytes/1024/1024 as decimal(6,0)) as megabytes, cast(affected as
decimal(7,0)) as files,successful from summary where
date(start_time)=date(current date) and time(start_time)>'18:00:00' and
time(end_time)<'23:59:59' and activity='ARCHIVE' order by start asc'

T.I.A Regards Robert
E-Mail: rouzen AT univ.haifa.ac DOT il
<Prev in Thread] Current Thread [Next in Thread>