(RADIATOR) sysdate with jus YYYYMM

[Bon sy]

Try this:

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


On Fri, 13 Aug 2004, Julio Cesar Pinto wrote:

> 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.
> 

--
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.