Iam trying to run a query in MS Access which has tables linked to Oracle.
The resultant of the query fetches a Date field. This field is in the format yyyy/mm/dd in Oracle. But in Access, I get it like yyyy/mm/dd 9:18 AM etc. why am I getting the time appended even though I do not see it in Oracle? I can use trunc in Oracle, but how do i get only the Date in Access from the query?
Pls. help!!!!!!!!!!!!!!
The resultant of the query fetches a Date field. This field is in the format yyyy/mm/dd in Oracle. But in Access, I get it like yyyy/mm/dd 9:18 AM etc. why am I getting the time appended even though I do not see it in Oracle? I can use trunc in Oracle, but how do i get only the Date in Access from the query?
Pls. help!!!!!!!!!!!!!!
