(RADIATOR) sysdate with jus YYYYMM

[Julio Cesar Pinto]

Hi,

I have a statement into AuthSQL clause, and I'd like to store in a table
one field with just YYYYMM, don't timestamp, my statement is:

AuthRejectQuery insert into TIMELIMITREJECT VALUES
('%{Ifx-Visp-Id}','%{Ifx-Country-Id}','%{Called-Station-Id}','%{Calling-
Station-Id}',sysdate,'%u','%{NAS-IP-Address}') 

My question is, can I modify the 'sysdate' value to store just YYYYMM.

I appreciate any comments.

Thanks a lot,

JC. 

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.