hi
i have this value in date field: 07/09/2010 07:34
how i can see this only: 07:34
how to do it in access 2007 and in C# format ?
thank's in advance
views:
32answers:
1
+1
A:
Try this:
Date dt = <value>;
String time = dt.ToString("hh:mm");
Use HH:mm for 24 hour format and hh:mm tt for 12 hour format with AM/PM.
Use this for reference:
http://authors.aspalliance.com/aspxtreme/sys/demos/datetimeformats.aspx
Sidharth Panwar
2010-09-07 19:06:11
thank's for the C# help, and how i can show this in access ?
Gold
2010-09-07 19:53:48
As in `SELECT Format([DateAndTime],"Short Time") AS TimeOnlyFROM SomeTable` ?
Remou
2010-09-07 22:23:24
thank's !!! it work's !!!
Gold
2010-09-08 05:33:22