Re: Informix with Powerbuilder

Posted in 1998

REDDY — Mon, 9 Mar 1998 08:28:07 -0600 (CST) — source: Informix-list mailing list archive (1991-1998)

Hi Syed, Use pb's "year" function to determine the year of a date value. Syntax: year(date) ==> returns integer. GetItemDate() returns date : Gets data whose type is Date. HTH Reddy On Mon, 9 Mar 1998, Syed wrote: > Hi everyone, > > Anyone here using Informix back-end with Powerbuilder front-end? I would > like to know how you extract the value of Year from the datetime field > defined in Informix using Powerscript language. The definition of > Datetime is Year to Year, how do i reference this in powerscript? i use > getitemdate() but it gives me runtime error. > > -- > ---------- Signature ----------- > Name: Syed Ibrahim > Address: Sapura Advanced Systems Sdn. Bhd, 18th Floor, Menara Tun Razak, > Jalan Raja Laut, 50350 Kuala Lumpur, Malaysia > Tel: (03) 295-3472, (03) 294-3000 Fax: (03) 294-6587, (03) 293-3154 >