I have a DQL query where I use "between date('05/15/2005 12:15:00',''mm/dd/yyyy hh24:mi:ss'') and date('09/15/2005 12:15:00',''mm/dd/yyyy hh24:mi:ss'')". When I run this query in my java program it works fine without any warnings but when I run this query in the iDQL command prompt it returns the result with this warning
[DM_LOCALE_W_ILLEGAL_DATE_FORMAT]warning: "Illegal syntax found in the date format 'mm/dd/yyyy hh24:mi:ss'. The default localized short date format will be used."
Can some one tell me how to rectify this problem?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.