Jannah Posted February 14, 2023 Group: Members Topic Count: 4 Topics Per Day: 0.01 Content Count: 6 Reputation: 0 Joined: 03/06/22 Last Seen: February 16, 2023 Share Posted February 14, 2023 Hello, I need a script example on how to compare dates obtain from SQL table to the current date in game. Basically I want to put freebies but it will expire on the designated date if not claimed. if the table is something like this Freebie ID / Freebie Item / Freebie Amount / Expiry / Expiry example : 2023-03-13 How should I query for expiry date and compare it to the date in game? Thank you. Quote Link to comment Share on other sites More sharing options...
0 Emistry Posted February 18, 2023 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10013 Reputation: 2348 Joined: 10/28/11 Last Seen: April 6 Share Posted February 18, 2023 https://www.w3schools.com/Sql/func_mysql_datediff.asp Quote Link to comment Share on other sites More sharing options...
Question
Jannah
Hello,
I need a script example on how to compare dates obtain from SQL table to the current date in game.
Basically I want to put freebies but it will expire on the designated date if not claimed.
if the table is something like this
Freebie ID / Freebie Item / Freebie Amount / Expiry /
Expiry example : 2023-03-13
How should I query for expiry date and compare it to the date in game? Thank you.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.