R Rob.Mills Registered User. Local time Today, 00:35 Joined Aug 29, 2002 Messages 871 Feb 11, 2004 #1 I am running a pass-through query on an Oracle server. I'm trying to break down a date field to see only the month. Is there an equivalent for Oracle to using Month([Date Field]) in Access?
I am running a pass-through query on an Oracle server. I'm trying to break down a date field to see only the month. Is there an equivalent for Oracle to using Month([Date Field]) in Access?
FoFa Registered User. Local time Yesterday, 23:35 Joined Jan 29, 2003 Messages 3,672 Feb 11, 2004 #2 tochar(datefields,'mm') if you require a numeric wrap in the tonumber function tonumber(tochar(datefields,'mm'))
tochar(datefields,'mm') if you require a numeric wrap in the tonumber function tonumber(tochar(datefields,'mm'))
