How To Extract A Unit Value From A Date And Time

How To Extract A Unit Value From A Date And Time


  • 23 Feb, 2012

    If you want to extract a specific date or time unit value out of a date or a time, you can use the EXTRACT(unit FROM expression) function. The tutorial exercise below gives you some good examples:ELECT EXTRACT(DAY FROM NOW()) FROM DUAL; 28ELECT EXTRACT(HOUR FROM NOW()) FROM DUAL; 23ELECT EXTRACT(SECOND FROM NOW()) FROM DUAL; 36

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.