By stevegula on

I'm trying to convert the stored blog entries in my personal blog to that of nodes in drupal. I store my dates as datetime timestamp (YYYYMMDD HH:MM:SS AM/PM) to whatever drupal uses. Unfortunately, I can't figure out what drupal uses. Is it doing date/time from the epoch? Is there an easy way for me to translate from my dates to drupal dates so I can keep my dates?

To get my stories inserted as proper nodes do I only need to insert in the node and node_revisions table?

⋅ Categories: Drupal 5.x

Comments

M.J. Taylor’s picture

M.J. Taylor commented

If you are in MySQL, try something like:

set @entry_date_time = unix_timestamp('2002-05-20 12:00:00');

From:

Generic Mass SQL Import into Drupal

M.J. Taylor
Publisher
from Reason to Freedom
Wekly libertarian magazine promoting thinking for oneself, thus helping to create a free, benevolent society.