problem in formatting date & time

[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?

 

[Mark Rae]

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?

Google is your friend...
http://www.google.co.uk/search?sour...G,GGLG:2006-28,GGLG:en&q=DataGrid+format+date

 

[Eliyahu Goldin]

Yes, use date and time formatting expressions. For example, "MMM d, yyyy"
will produce Aug 27, 2006.