hello everyone!!
I really need your help with a problem that i've encountered during a development of a custom resource class.
I've a CRC with some dates, I've one field for a starting date and another one for a ending date of an event:
start_date (datetime in SQL)
end_date (datetime in SQL)
And i've another field, for every day of an event for the starting time and ending time.
I would treat this field as TimeField (H:i)
My question is: how could I set type of field in SQL Schema? When I try to edit departure_time my database don't save any change. I try "time", "timestamp", "datetime" without any result.
<field key='departure_time' dbtype='timestamp' phptype='date' null='true'/>
<field key='departure_time' dbtype='date' phptype='date' null='true'/>
<field key='departure_time' dbtype='datetime' phptype='date' null='true'/>
Should I make some php function in create/update process first of save it on database??
I've a grid with a list of days:
,
{ name: 'departure_time', type: 'date' }
{
header: 'departure_time'
,dataIndex: 'departure_time'
,sortable: true
,width: 250
,editor: { xtype: 'timefield', format:'H:i'
}
}
Thx in advice.
Francesco
☆ A M B ☆