Store Datetime in sql Server
02/12/2014 09:30 Pm---dd/mm/yyyy hh:mm tt
and get this date from Sql server to label in asp
i want query for both insert and select
thank u
advance wish u happy new year
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Manish Kumar ChoudharyPosted Jan 2, 2015, 11:02 PM
Hi muthukumar,
No need to convert date format while inserting a data in sql server. And use normal select query and with date column use
lbl1.Text=.ToString("dd/mm/yyyy hh:mm tt");
Front end it will convert the date format and display it in your label.
Murugesh PPosted Jan 2, 2015, 8:12 AM