Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 5 of 5 total

Wed, Aug 8 2018 10:45 PM	Permanent Link
Ian Branch	Hi Tim, Any chance of a DAYOFMONTH to complement DAYOFWEEK & DAYOFYEAR for the EXTRACT function?? e.g. EXTRACT(DAYOFMONTH FROM CURRENT_DATE) Regards, Ian
Thu, Aug 9 2018 1:42 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Ian I'm not sure you want such an expression to return. Unless you're after something special I think it might EXTRACT(DAY FROM date/timestamp) Roy Lambert
Thu, Aug 9 2018 2:34 AM	Permanent Link
Ian Branch	Hi Roy, Same, same as DayOfWeek except it would return 1 - 31 as appropriate to the month. Regards, Ian
Thu, Aug 9 2018 2:35 AM	Permanent Link
Ian Branch	Hmm. on reflection, yes EXTRACT(DAY FROM date/timestamp) would do the job.
Thu, Aug 9 2018 4:38 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Ian >Hmm. on reflection, yes EXTRACT(DAY FROM date/timestamp) would do the job. <giggle> Roy