I have done it in Oracle using to_date() and to_char(). Maybe the link below can help you.http://www.hhisoftware.com/oracle-access.htm