| Index
» Projects
» phpMyEdit
» Bug list
» Bug #260 |
 |
|
Viewing Bug Advanced Details |
[ Jump to Bugnotes ]
[ Bug History ]
[ Print ]
|
|
ID |
Category |
Severity |
Reproducibility |
Date Submitted |
Last Update |
|
0000260 |
core / general |
minor |
always |
2004-08-24 04:49 |
2004-08-26 12:18 |
|
|
|
Reporter |
doug |
View Status |
public |
|
|
Assigned To |
|
|
Priority |
normal |
Resolution |
open |
Platform |
|
|
Status |
confirmed |
Duplicate ID |
|
OS |
|
|
Projection |
none |
|
Version |
|
|
ETA |
none |
|
Product Version |
5.3 (stable) |
|
|
Product Build |
|
|
|
Votes |
1 |
|
|
|
Summary |
'datemask' => 'H:i:s', with TIME column |
|
Description |
Perhaps this is noted, or fixed, elsewhere and I was unable to find it. Using class file:
/* $Platon: phpMyEdit/phpMyEdit.class.php,v 1.143 2004/04/22 16:15:14 nepto Exp $ */
with 'datemask' => 'H:i:s' only displays an empty cell when one would expect to see something like "08:00:00" as the value.
$opts['fdd']['time_col'] = array(
'datemask' => 'H:i:s',
'default' => '00:00:00',
'input' => '',
'maxlen' => 8,
'name' => 'Time Col',
'options' => 'ACPVDFL',
'required' => true,
'select' => 'T',
'size|ACP' => 8,
'sqlw' => 'TRIM("$val_as")',
'sort' => true
);
|
|
Steps To Reproduce |
|
|
Additional Information / Solution |
|
|
Attached Files |
|
|
|
|
Bug Notes |
michal
2004-08-25 12:20
|
the problem is that time_col is not a datetime but a time column (?). calling unixtimestamp on it causes some problems :). i'm not sure if this is currently solved in the core class. |
|
|
nepto
2004-08-26 12:18
|
Yes, I can confirm this bug.
When ['datemask'] is used, UNIX_TIMESTAMP(col_name) is used when retrieving data from DB. However UNIX_TIMESTAMP() on TIME column returns always 0.
Probably some hacks with ['sql'] can solve this.
However TIME column retrieved from DB is already in H:i:s format, you do not need to use ['datemask]. And if you want to remove seconds from the time, you can use ['mask'] = '%.5s' option. |
|
|
|
Bug History |
|
Date Modified |
Username |
Field |
Change |
|
2004-08-24 04:49 |
doug |
New Bug |
|
|
2004-08-25 12:20 |
michal |
Bugnote Added: 0001169 |
|
|
2004-08-26 12:18 |
nepto |
Bugnote Added: 0001173 |
|
|
2004-08-26 12:18 |
nepto |
status |
new => confirmed |
|
|
Login
Registration
Slovak
