"ORA-01843: not a valid month" or
"ORA-01830: date format picture ends before converting entire input string"
This error means that a date was used in the SQL but that Oracle did not consider the month to be a valid month.
False ;
AUDIT_MODIFY_DATE >= to_date('9/19/2006 3:13:10 PM','DD/MM/YYYY HH24:MI:SS')
True ;
AUDIT_MODIFY_DATE >= to_date('19/9/2006 3:13:10 PM','DD/MM/YYYY HH24:MI:SS')
when you use casting operation at datetime data like this:
DateTime lastActionDate = DateTime.Now;
lastActionDate = (DateTime)ds.Tables[0].Rows[0]["CREATEDATE"];
you may set your regional settings for datetime pattern at codebehind.
DateTimeFormatInfo.ShortDatePattern Property gets or sets the format pattern for a short date value. At this time you can use below statements at top of your method :
CultureInfo c = new CultureInfo("tr-TR") ;
System.Threading.Thread.CurrentThread.CurrentCulture = c;
System.Threading.Thread.CurrentThread.CurrentUICulture = c;
System.Threading.Thread.CurrentThread.CurrentCulture.DateTimeFormat.
ShortDatePattern = "dd/MM/yyyy";
Related Terminology : Oracle datetime problem, CurrentCulture, CurrentUICulture
|