Steps to reproduce:

1. Create a new blog post in Confluence 4.0
2. Run the following query against the database to list all created blogs sorted by CREATIONDATE:

   SELECT TITLE, CREATIONDATE, LASTMODDATE
   FROM CONTENT
   WHERE CONTENTTYPE='BLOGPOST'
   AND PREVVER IS NULL
   ORDER BY CREATIONDATE;
   

3. The timestamp of newly created blog post is set to 00:00:00 e.g. SQL1.png

The issue does not occurred in Confluence 3.5.x. This seems to be broken in 4.0.