Getting day, month and year apart from Db

Getting day, month and year apart from Db

pooja7r
Newbie
Posts: 2
Threads: 0
Joined: Mar 2018
Reputation: 0

03-23-2018, 06:19 AM

The following expressions return the day for each date in the input port
GET_DATE_PART ( DATE_SHIPPED, 'D' )
Get month from a date
GET_DATE_PART ( DATE_SHIPPED, 'MM' )
Get year from a date
GET_DATE_PART ( DATE_SHIPPED, 'Y' )

Messages In This Thread

Getting day, month and year apart from Db - by jordyd - 03-09-2018, 03:45 PM

RE: Getting day, month and year apart from Db - by enelson - 03-12-2018, 12:20 PM

RE: Getting day, month and year apart from Db - by ivantcholakov - 03-12-2018, 01:01 PM

RE: Getting day, month and year apart from Db - by ivantcholakov - 03-12-2018, 01:20 PM

RE: Getting day, month and year apart from Db - by Mr Lister - 03-18-2018, 02:19 AM

RE: Getting day, month and year apart from Db - by jordyd - 03-19-2018, 01:23 AM

RE: Getting day, month and year apart from Db - by pooja7r - 03-23-2018, 06:19 AM