# CURRENT\_TIMESTAMP shows all zeroes **URL:** \ **Category:** MySQL database\ **Created:** [February 19, 2021, 1:05am UTC](https://www.phphelp.com/t/current-timestamp-shows-all-zeroes/33155 "2021-02-19T01:05:25Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Pedroski55](https://www.phphelp.com/letter_avatar_proxy/v4/letter/p/a4c791/32.png) [@Pedroski55](https://www.phphelp.com/u/Pedroski55)\ **Post date:** [February 19, 2021, 1:05am UTC](https://www.phphelp.com/t/current-timestamp-shows-all-zeroes/33155/1 "2021-02-19T01:05:25Z")
I’m using MySQL and myphpadmin on my webhost. I have a column logon\_time in the table allstudents19BE, set as TIMESTAMP I was hoping it would show me the logon time, especially after any update. When I look at the table structure in myphpadmin, the column logon\_time has: type: timestamp default: CURRENT\_TIMESTAMP extra: ON UPDATE CURRENT\_TIMESTAMP I am making new tables for a new school term, so I thought, maybe creation doesn’t count as update. I imported the csv file again with some different data in it. The timestamp in the column logon\_time stays the same. What am I doing wrong? Why am I not getting the CURRENT\_TIMESTAMP?? ---
**Author:** ![skawid](https://www.phphelp.com/letter_avatar_proxy/v4/letter/s/bbe5ce/32.png) [@skawid](https://www.phphelp.com/u/skawid)\ **Post date:** [February 19, 2021, 7:59am UTC](https://www.phphelp.com/t/current-timestamp-shows-all-zeroes/33155/2 "2021-02-19T07:59:45Z")
How are you importing the CSV? ---
**Author:** ![Pedroski55](https://www.phphelp.com/letter_avatar_proxy/v4/letter/p/a4c791/32.png) [@Pedroski55](https://www.phphelp.com/u/Pedroski55)\ **Post date:** [February 22, 2021, 2:57am UTC](https://www.phphelp.com/t/current-timestamp-shows-all-zeroes/33155/3 "2021-02-22T02:57:11Z")
Importing with phpMyAdmin, or my own little importCSV.php