The node created and updated timestamps are stored in the base "node" table.

e.g

$result = db_select('node', 'n')
->fields('n', array('nid', 'title', 'created', 'changed'))
->orderBy('nid')
->range(0,10)
->execute();

foreach($result as $row){
  drupal_set_message('<pre>'.print_r($row,1).'</pre>');
}

The node created and updated timestamps are stored in the base "node" table.

e.g

$result = db_query("SELECT nid, title, changed, created FROM {node} ORDER BY nid ASC LIMIT 10");

while($row = db_fetch_object($result)){
  // drupal_set_message($row->title);
  drupal_set_message('<pre>'.print_r($row,1).'</pre>');
}

The node created and updated timestamps are stored in the base "node" table.

The node created and updated timestamps are stored in the base "node" table.

e.g

$result = db_select('node', 'n')
->fields('n', array('nid', 'title', 'created', 'changed'))
->orderBy('nid')
->range(0,10)
->execute();

foreach($result as $row){
  drupal_set_message('<pre>'.print_r($row,1).'</pre>');
}