Oninit cdi / Archive
Talk to an expert →

How to get the DAY OF YEAR - IDS10 UC5

Posted in 2007

Topics: General Discussion

Navaid Arif — — source: IIUG Forums & Mailing Lists

Hi All, Is there any built-in function in INFORMIX to get the day of year? I am using IDS10 UC5. For example, it should return 360 for the date 26-Dec-2007. Regards, Navaid Arif

↪ replying to Navaid Arif
Mike Aubury — — source: IIUG Forums & Mailing Lists

AFAIK - theres no builtin - but its easy to work out : eg. today-mdy(1,1,year(today))+1 On Wednesday 26 December 2007 07:21:29 Navaid Arif wrote: > Hi All, > > Is there any built-in function in INFORMIX to get the day of year? I am > using IDS10 UC5. For example, it should return 360 for the date > 26-Dec-2007. > > Regards, > Navaid Arif > > > *************************************************************************** >**** Forum Note: Use "Reply" to post a response in the discussion forum. > > See you at the IIUG Informix 2008 Conference > The Power Conference for Informix Professionals > April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas > http://www.iiug.org/conf > Registration Now Open!!

↪ replying to Mike Aubury
Navaid Arif — — source: IIUG Forums & Mailing Lists

Thanks Mike. Regards, Navaid Arif . ----- Original Message ----- From: "Mike Aubury" <iiug@aubit.com> To: <ids@iiug.org> Sent: Wednesday, December 26, 2007 2:54 PM Subject: Re: How to get the DAY OF YEAR - IDS10 UC5 [10798] > AFAIK - theres no builtin - but its easy to work out : > > eg. > > today-mdy(1,1,year(today))+1 > > On Wednesday 26 December 2007 07:21:29 Navaid Arif wrote: >> Hi All, >> >> Is there any built-in function in INFORMIX to get the day of year? I am >> using IDS10 UC5. For example, it should return 360 for the date >> 26-Dec-2007. >> >> Regards, >> Navaid Arif >> >> >> *************************************************************************** >>**** Forum Note: Use "Reply" to post a response in the discussion forum. >> >> See you at the IIUG Informix 2008 Conference >> The Power Conference for Informix Professionals >> April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas >> http://www.iiug.org/conf >> Registration Now Open!! > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > See you at the IIUG Informix 2008 Conference > The Power Conference for Informix Professionals > April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas > http://www.iiug.org/conf > Registration Now Open!! >

Related threads