format integer number in MySQL
Database
2
Posts
2
Posters
0
Views
1
Watching
-
Hi, In MySQL, how can I format a number like this 1000000001 where the first 1 is the weekday and the last one is my LAST_INSERT_ID and I am adding just zeroos to make it always 10 digits?
-
Hi, In MySQL, how can I format a number like this 1000000001 where the first 1 is the weekday and the last one is my LAST_INSERT_ID and I am adding just zeroos to make it always 10 digits?
How about this:
SELECT (DAYOFWEEK(NOW()) * 1E9) + @@LAST_INSERT_ID