The following command shows us the week of the month, week of the year, month of a quarter and the current quarter of the year for a particular date, which is July 20, 2007.
SELECT week_of_month,
week_of_year,
month_of_quarter,
quarter_of_year
FROM sys_calendar.calendar
WHERE calendar_date=1070720;
Where the string 1070720 is broken down as follows;
1st three digits represents the number of years from 1900. For example current year is 2007 and the base year is 1900 then first three digits are 2007-1900 which is 107.
2nd two digits represents month in the year.
3rd two digits represents day of the month.
To see all the attributes of the sys calendar, try the following command.
SELECT *
FROM sys_calendar.calendar
WHERE calendar_date=1070720;
Our Random Articles
- Somdev Devvarman ousts Xavier Malisse 6-1, 3-6,7-6(5)
- How To Choose A Good Online Traffic School
- New Year Wishes 2010
- New Year Wishes
- How to use EXTRACT function with date and time columns
More Links
4 Comments
Material that you are providing is very easy to learn. But it is much better than this , if you ll give the full material of this at ONE LINK.
Thank you
Suresh.
That is right Suresh. This is the reason I have given all the links in one page, please visit this
http://readvitamin.com/teradata/
Hope this helps.
Hi. Can anyone tell me how to extract time from timestamp?
For Example
timestamp=’2008-03-28 14:11:04′
i want time ’14:11:04′ from timestamp through query.
Thanks in advance.
Hi Vaideesh,
If you need only time, you can probably try the following;
SELECT time;
To answer your question you should do something like this.
SELECT CAST(VaideeshTime as time(0)) from timestamp;
VaideeshTime
——–
14:11:04
Hope that helps.