>> "Andrus Moor" <[EMAIL PROTECTED]> writes:
>>
>>> I have a table containing month column in format mm.yyyy
>>>
>>> create table months ( tmkuu c(7));
>>> insert into months values ('01.2005');
>>> insert into months values ('02.2005');
>>>
>>> How to create select statement which converts this column to date
>>> type containing last day of month like
>>>
>>> '2005-01-31'
>>> '2005-02-28'
>>
>> The usual trick is to split it into year and month, add 1 to the
>> month, if that's > 12, jump to 1, and add a year.
>>
>> Based on those... Construct the first day of the NEXT month.
Try this (my date is current_date):
select date_trunc('month', current_date + '1 month'::interval) - '1
day'::interval
-------------------------------------------
Bastianello Luciano - MBS CP Development
Software Consultant - Apprentice Sorcerer
http://community.visual-basic.it/LucianoB/
e-mail: [EMAIL PROTECTED]
MSN: [EMAIL PROTECTED] - ICQ: 209754422
AIM: lubastia - YAHOO lbastianello
-------------------------------------------
___________________________________
Yahoo! Mail: gratis 1GB per i messaggi e allegati da 10MB
http://mail.yahoo.it
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
