Getting the date at the end of a query

[rallingham]

I know that I can do a command for the admin command line like: q drm > c:\tmp\q_drm.txt and the data will go to a txt file. I also know that I can append by using >>. My question is this. Is there a way to add the system date on to the outuput so that it would be like: q drm > c:\tmp\q_drm.date or something like that? Anyone?

 

[Harry_Redl]

Hi,

what about
issue message I SystemDate
select date_time from actlog where message like 'ANR1496I SystemDate%' and cast(minute(current_timestamp-date_time) as decimal) < 5 >>sysdate.txt

Harry

 

[rallingham]

Thank you. I will give that a try.