Index: trunk/Ohana/src/opihi/cmd.data/dbselect.c
===================================================================
--- trunk/Ohana/src/opihi/cmd.data/dbselect.c	(revision 17648)
+++ trunk/Ohana/src/opihi/cmd.data/dbselect.c	(revision 17852)
@@ -5,4 +5,5 @@
 int dbselect (int argc, char **argv) {
   
+  time_t seconds;
   int i, j, Nbytes, Ncols, Nrows;
   char *query;
@@ -81,5 +82,24 @@
     for (i = 0; i < Ncols; i++) {
       if (row[i]) {
-	vec[i][0].elements[j] = atof (row[i]);
+	switch (fields[i].type) {
+	  case FIELD_TYPE_TINY:
+	  case FIELD_TYPE_SHORT:
+	  case FIELD_TYPE_LONG:
+	  case FIELD_TYPE_INT24:
+	  case FIELD_TYPE_LONGLONG:
+	  case FIELD_TYPE_DECIMAL:
+	  case FIELD_TYPE_FLOAT:
+	  case FIELD_TYPE_DOUBLE:
+	    vec[i][0].elements[j] = atof (row[i]);
+	    break;
+	  case FIELD_TYPE_TIME:
+	  case FIELD_TYPE_DATE:
+	  case FIELD_TYPE_DATETIME:
+	    seconds = ohana_date_to_sec (row[i]);
+	    vec[i][0].elements[j] = ohana_sec_to_mjd (seconds);
+	    break;
+	  default:
+	    vec[i][0].elements[j] = NAN;
+	}
       } else {
 	vec[i][0].elements[j] = NAN;