HOW CAN WE GET THE WEEK INFO FROM DATE in Vertica DB?

[gvkiranreddy]

HOW CAN WE GET THE WEEK INFO FROM DATE in Vertica DB?
Hi,

SELECT WEEK('2008-02-20') FROM DUAL; in ORACLE

how to extract in vertica?

Can any one please give me the solution for above query.
        

[nnani]

Hello,

I have take same example as yours for the solution
The solution for getting week number for the year

Code: Select all

nnani=> select week('2008-02-20');
 week
------
    8
(1 row)

nnani=>

Hope this helps.