Reply to thread

Message: <blockquote data-quote="aluthKolla0001" data-source="post: 20642971" data-attributes="member: 555793">Machan, mehema karanna puluwan, datetime column eka date part ekai time part ekai wena wenama split karala compare karanna puluwan(cast karanna pluwan)mysql> select cast('2011-10-24 15:20:10' as date);+-------------------------------------+| cast('2011-10-24 15:20:10' as date) |+-------------------------------------+| 2011-10-24                          |+-------------------------------------+1 row in set (0.00 sec)mysql> select cast('2011-10-24 15:20:10' as time);+-------------------------------------+| cast('2011-10-24 15:20:10' as time) |+-------------------------------------+| 15:20:10                            |+-------------------------------------+1 row in set (0.00 sec)Ita passe oya date, time kiyana parameters walata where clouse eka dala exact match karanna . Nethnam > ,<, <=, >= wage dala compare karanna date time range walata. Ekata oni nam client UI eken dena value eka poddak hadala ewanna php walin, ita passe apahu compare karanna ona ne.</blockquote>

Top Bottom