Query-Question with 4Y2M

Posted in 1998

andy@pneu.com — Tue, 13 Oct 1998 14:49:53 GMT — source: Informix-list mailing list archive (1991-1998)

Hello! i search for a way in sql to get an output jear and month like that: yyyymm ...where mm must have an leading zero for months < 10. column-type is date. my idea select YEAR(today) && MONTH(today) from anytable does not work, the zero is missing..... in ace and 4gl, i would use "using....", but in sql? Any Ideas (without changing any DBDATE-settings) ? Bye Andy M. Bettin -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own