Not preserving time format while exporing to excel

Question

Hi All ,

I tried to export XML data to excel using datasets which includes one column of 24 hr format time in my table .
Now when it is exported to excel it is displaying in 12 hr format .I want to preserve the 24 hr format.

Please suggest me the solution .

Answer 1

Please go through below links that might help you:

 

http://www.w3schools.com/php/php_mysql_insert.asp

 

http://www.tutorialspoint.com/php/mysql_insert_php.htm

 

http://people.cis.ksu.edu/~hankley/d764/tut06/GopisettyPHP.html 

Answer 2

Hi Sharfeena,

 

If you are creating database table in server on runtime then it is not good idea. Create a table and on click of "Add House" you should add record in the table.

 

Please let us know where are you getting stuck? 

Answer 3

Hi,

     Thank you for the information.i need one more help.i don't know how to create

      record with in the table . plz send the code .