Re: Query-Question with 4Y2M

Posted in 1998

Paul Roberts — 30 Oct 1998 04:06:36 GMT — source: Informix-list mailing list archive (1991-1998)

## 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..... How about this:- select year(today) * 100 + month(today) from anytable It's going to return an integer such as 199802. - Paul