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.
HOW CAN WE GET THE WEEK INFO FROM DATE in Vertica DB?
Moderator: NorbertKrupa
-
- Newbie
- Posts: 9
- Joined: Tue May 21, 2013 7:09 am
Re: HOW CAN WE GET THE WEEK INFO FROM DATE in Vertica DB?
Hello,
I have take same example as yours for the solution
The solution for getting week number for the year
Hope this helps.
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=>