Although date formats vary from database to database, and even between applications,
Data Integration
can read any date with a date datatype.
In general, dates stored in databases contain a date and time value. The date includes the month, day, and year, while the time might include the hours, minutes, and seconds. You can pass datetime data to any of the date functions.