| Index
» Projects
» phpMyEdit
» Forum
» striftimemask |
 |
JammerPro
Joined: 07 Dec 2006
Posts: 33
Posted: 2009-07-24 05:57
Back to top
Reply with quote
|
Mysql database contains a time field that is set to default 00:00:00 (24 hour format).
I would like to use the strftime mask so that I can enter a time like 7:00 pm in phpmyedit and have the data base field see it as 19:00:00.
This DOES NOT work:
$opts['fdd']['EventTime']= array(
'name' => 'EventTime',
'select' => 'T',
'maxlen' => 8,
'strftimemask' => '%r',
'default' => '00:00:00',
'sort' => true
);
Any suggestions?
|
doug
Joined: 10 Feb 2003
Posts: 1013
Location: Denver, Colorado (USA)
Posted: 2009-07-25 02:11
Back to top
Reply with quote
|
You would need to write some triggers to evaluate and conditionally modify $newvals['EventTime']. Probably not easy to accomplish.
You might find some examples if you search the forum for a few words such as: triggers time format
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
