SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 15/02/2015, 11:04 PM   #1
aa
Little Clucker
 
Join Date: Aug 2010
Posts: 12
Reputation: 0
Default Saving Date & Time MYSQL

I don't know how to save date & time in mysql database.

I have tried few things from forum but no luck.

"NOW()" function. ...
aa is offline   Reply With Quote
Old 15/02/2015, 11:20 PM   #2
Vince
Spam Machine
 
Vince's Avatar
 
Join Date: Sep 2007
Location: Belgium
Posts: 10,962
Reputation: 2649
Default Re: Saving Date & Time MYSQL

I would recommend Unix timestamps for best accuracy. Even though the datetime type is more readable, it imposes certain problems if the timezone is changed (such as when a server is moved from one location to another).
__________________
Vince is offline   Reply With Quote
Old 16/02/2015, 02:43 AM   #3
aa
Little Clucker
 
Join Date: Aug 2010
Posts: 12
Reputation: 0
Default Re: Saving Date & Time MYSQL

Any tutorial how to or something? I'm on my phone with slow internet connection.
aa is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[HELP] date mysql saving format type Luca12 Scripting Help 11 09/08/2014 05:40 PM
[HELP] mysql saving date Luca12 Scripting Help 7 07/06/2014 10:33 PM
Mysql date saving problem Dancev96 Scripting Help 3 21/04/2014 07:15 PM
Date+time+MySQL x96664 Scripting Help 10 16/12/2013 12:37 AM
Problem saving ban reason / ban date mysql EleMenTalL Server Support 2 25/03/2012 02:16 AM


All times are GMT. The time now is 03:15 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.