Geeks With Blogs
Saqib Ullah BootStrapper Know How

This is a simple query that give us Time and Date seperatly from Date Type in MS SQL 2000.

Select P.Code, Convert(Varchar,P.ArrivalTime,1) as Product_Date, Convert(Varchar,P.ArrivalTime,8) as Product_Time from Product P.

If you Change 1 and 8 in the Convert function you get new formates. I Know that its very simple .


Posted on Friday, March 9, 2007 9:55 AM | Back to top

Comments on this post: I Want Date and Time

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Saqib Ullah | Powered by: