How are dates stored in Drupal?

I cannot seem to find anywhere in the documentations that tells me how dates are stored in a mySQL database. I want to write an SQL query without using the API and need to know how to select and format dates.