But there are ways you can get rid of the same, except leaving early, you can check the traffic information and change your route plans. Before that, just to let you know that most of the congestions happens near to an exit/merge of another interstate during long weekend travellors, so avoid this.
Google maps gives a good piture of what is traffic condition
Also if you are in Bay area, there is a good site that gives information uptodate.
http://traffic.511.org/traffic_map.asp
For a nation wide traffic information. check the following website after entering your zip code.
This website also give jamfactor measurement which tells how much more time you need to get to your destination.
Happy Travelling….
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.