S sushmitha Registered User. Local time Today, 08:06 Joined Jul 30, 2008 Messages 55 Aug 15, 2008 #1 I have a Datetime field in my table in format m/dd/yyyy hh:mm:ss AM How to get only date from this datetime field ?? I need to display the field only for Date like 'MM/DD/YYYY' Thanks for your help
I have a Datetime field in my table in format m/dd/yyyy hh:mm:ss AM How to get only date from this datetime field ?? I need to display the field only for Date like 'MM/DD/YYYY' Thanks for your help
N namliam The Mailman - AWF VIP Local time Today, 14:06 Joined Aug 11, 2003 Messages 11,693 Aug 15, 2008 #2 Either you need to set the "format" to "mm/dd/yyyy" or try Trunc(yourfield) to trim the time off.
N namliam The Mailman - AWF VIP Local time Today, 14:06 Joined Aug 11, 2003 Messages 11,693 Aug 15, 2008 #3 Your right Pat, sorry... Frigging Oracle... I am beeing totaly oracle-ised ... Tho in Oracle trunc does most definatly work on date/time fields to be trunced to a date only.
Your right Pat, sorry... Frigging Oracle... I am beeing totaly oracle-ised ... Tho in Oracle trunc does most definatly work on date/time fields to be trunced to a date only.
R raskew AWF VIP Local time Today, 07:06 Joined Jun 2, 2001 Messages 2,733 Aug 17, 2008 #4 Pat - Apparently it's stranger than that. See: http://www.techonthenet.com/oracle/functions/trunc_date.php Bob
Pat - Apparently it's stranger than that. See: http://www.techonthenet.com/oracle/functions/trunc_date.php Bob
