Title:
Bug 83421:(Watson Migration Closure)Summary: Lack of uniformity in support for date parts
| View in TrackerStatus/Resolution/Reason: Closed/Deferred/
Reporter/Name(from Bugbase): Adam Cameron / Adam Cameron (Adam Cameron)
Created: 06/22/2010
Components: Language, Functions
Versions: 9.0
Failure Type: Unspecified
Found In Build/Fixed In Build: 0000 /
Priority/Frequency: Normal / Unknown
Locale/System: English / Platforms All
Vote Count: 1
Problem:
Summary: Lack of uniformity in support for date parts
dateCompare() supports these (this is all according to the docs, anyhow):
s : Precise to the second (default)
n : Precise to the minute
h : Precise to the hour
d : Precise to the day
m : Precise to the month
yyyy : Precise to the year
dateDiff():
yyyy: Years
q: Quarters
m: Months
y: Days of year (same as d)
d: Days
w: Weekdays (same as ww)
ww: Weeks
h: Hours
n: Minutes
s: Seconds
dateAdd():
yyyy: Year
q: Quarter
m: Month
y: Day of year
d: Day
w: Weekday
ww: Week
h: Hour
n: Minute
s: Second
l: Millisecond
Is there any reason why these functions don’t all support the same set of date masks?-- Adam
Method:
Result:
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3041694
External Customer Info:
External Company:
External Customer Name: Adam Cameron
External Customer Email: 17EB1A7649DA54C7992015A9
External Test Config: 06/22/2010Attachments:
Comments: