problem in formatting date & time

  • Thread starter Thread starter psycho
  • Start date Start date
P

psycho

in sqlserver in date is stored in a particular format. Date and time
are stored in same column. so if i want to display only date or only
time in the datagrid is there any solution?
 
Yes, use date and time formatting expressions. For example, "MMM d, yyyy"
will produce Aug 27, 2006.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format Datagrid column to show only date (without time) 2
Pivot table macro filter data between yesterday and today (date+time) 0
Easy way to convert datetime (mysql) 1
How a UTC stored date column in a gridview, displays in localtime? 1
Regional Date Format? 1
International datetime comparisons in real-time web apps 1
Access General Date Forced To Have Date And Time 2
Change Format for Date 1

Back
Top