YEAR in active record |
HI , i have a table :
`id` bigint(20) UNSIGNED NOT NULL, `data` date NOT NULL, `numero_settimana` int(11) NOT NULL, `giorno_settimanale` varchar(15) NOT NULL, `orari_apertura_id` int(11) NOT NULL, `stato_agenda_id` int(10) UNSIGNED NOT NULL COMMENT '= aperto chiuso o prenotato', `clienti_id` int(10) UNSIGNED DEFAULT NULL, `note` varchar(100) DEFAULT NULL This is a part my function : PHP Code: getweek($numsettimana,$data,$tabella){
Try this and see if it is what you want, not tested.
PHP Code: $query = $this->db->select('SELECT DATE("{$data}") as required_DATE') What did you Try? What did you Get? What did you Expect?
Joined CodeIgniter Community 2009. ( Skype: insitfx )
PHP Code: function getweek($numsettimana, $data, $tabella){
Hello,
I just read your question. I think you need to change the data type. you have to need to change your field data type for 'numero_settimana' int to DATE. Hope it will help you friend. |
Welcome Guest, Not a member yet? Register Sign In |