How can I remove time part of a timestamp?
So for example turn 1310571061
to 1310565600
which is the plain date timestamp.
In the "Format Cells" dialog box, on the "Number" tab, select the category "Custom," and choose the type "h:mm" or "h:mm:ss" depending on whether seconds need to appear. 6. Select "Ok."
Remove Time from Date Using Find and Replace Select all the timestamps from which you want the time removed. Go to Home tab > Find & Select button > Replace… option or press Ctrl + H to open the Find and Replace dialog box. In the Find what field, type a space character and an asterisk "*".
strtotime(date("Y-m-d", 1310571061));
That should do it for you.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With