2. PHPRunner General questions
  3. [SOLVED]  Concat Date + Time = Datetime
This topic is locked
[SOLVED]

 Concat Date + Time = Datetime

 		3/14/2013 12:47:36 PM
PHPRunner General questions
W
 wrjost author

Hi,

I have three fields in the same table: reg_date (date), reg_time (time) and reg_datetime (datetime).
reg_date and reg_time are required fields on the add page. When the user saves the data, these two values should be saved as the third field, reg_datetime.
Any ideas?
Thank you in advance,

Wilfried
C
 		copper21 3/14/2013

Hello,
I just worked on something similar. Add this to "Add Page: After record Added"
$reg_date = date("m-d-Y",strtotime($values['reg_date']));
$reg_time = date("H:i:s",strtotime($values['reg_time']));
$reg_datetime = $reg_date.' '.$reg_time;
global $conn;

$sql = "UPDATE YOUR_TABLE_NAME SET reg_datetime = $reg_datetime WHERE KEYFIELD = ".$values['KEYFIELD']."";

CustomQuery($sql);
Hope this helps,
Brian
C
 		cgphp 3/14/2013

You can do it in three lines:

$reg_date = date("Y-m-d", strtotime($values['reg_date']));

$reg_time = date("H:i:s", strtotime($values['reg_time']));

$values['reg_datetime'] = $reg_date.' '.$reg_time;
S
 		swanside 3/19/2013

How about just adding a timestamp field to the Database?