transform language and Dates

oldforum

• July 16, 2007 00:00

• Answered

Follow

I am trying to merge 2 inputs together each one has an activity_date field and i want to have the most recent date to come out of the merge. the code i am using is


date activity_date;
if ($table1.activity_date > $table2.activity_date) {
activity_date = $table1.activity_date;
}
else {
activity_date = $table2.activity_date;
}


the dates in the tables are in yyyy-mm-dd hh:mm:ss format and in the destination table the field is the same. however when i run the graph the date entered in the final table loses the time data and is in yyyy-mm-dd 12:00:00 AM format how cna i fix this

• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  well i found out what it is. MS SQL Server does not like the default date form of Tue Nov 28 16:16:48 EST 2006.
• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  Hi !
  
  Can you try to use print_err() to show what value is actually in activity_date after the if statement ?
  
  It should contain date&time info. Question is how is it defined on the "final table" side - do you mean output data file or database table.
  
  If database table, then the DB data type may not support time information.
  
  If clover data file (text file) then it depends on the metadata - you should have it with format specified and it must contain time - something like this "yyyy-MM-dd HH:mm:ss"

Please sign in to leave a comment.