Hai 2 All, Am Writing Sql Statement for getting date select convert ( varchar(19),getdate(),103) out put : (No column name) 01/01/2015 but i want to display date as 01-jan-2015