date format

Question

How does one remove or avoid the time part from a date/time field value. For example stored in database as 9/15/2012 11:36:06 AM but we have to retrive in label as 15/9/2012 only from table....

sudharsan s · Answer

use this query to retrive the date from datetime select convert (varchar(10)created_date111) from category created_date=== your database datetime column name category==== category is table name replace this as per your database and try. additinal info: 111=== indicate the date format

Kunal Vaishya · Answer

Dear you get all different type of format but you get it in varchar you can set in label for display purpose Select convert (varchar date111) from category Or Select convert (Varchar GetDate()111) you will get 2012/07/05 Or Select convert (Varchar GetDate()101) Out Put Get :07/05/2012 Select convert (Varchar GetDate()102) Out Put Get :2012.07.05 Select convert (Varchar GetDate()103) 05/07/2012 Select convert (Varchar GetDate()104 05.07.2012 Select convert (Varchar GetDate()105) 05-07-2012 Set As Per Requirement

Manikavelu Velayutham · Answer

http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx YOu can dispaly the date value in any format by converting to string using formats available in the above link.