Skip to Content
0
Former Member
May 23, 2013 at 11:07 PM

errro retrieving the day from a date

23 Views

Hi,

I am trying to extract the day from a "date time" field.

I 'm trying using trunc(date_field,'dd') and doesnt work.

I am working with a view in oracle database but is filled with data from MS SQL SERVER database using a database link.

The problem is when I use a oracle function send an error from MS SQL and whrn I use a MS SQL function send me a error from oracle