By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,728 Members | 2,488 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,728 IT Pros & Developers. It's quick & easy.

problem in formatting date & time

P: n/a
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?

Aug 27 '06 #1
Share this Question
Share on Google+
2 Replies


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

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
"psycho" <pa***********@gmail.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...
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?

Aug 27 '06 #2

P: n/a
"psycho" <pa***********@gmail.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...
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?sourc...id+format+date
Aug 27 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.