I don't think you should try to convert the UNIXTIME to a DATE format.
Just take time() minus the joindate from the table (in UNIXTIME) and subtract them and divide by the number of days in seconds to get the number of days. No need to convert to DATE format.
Or whatever you like, but your query is broken... try again
PS: There is no field in the user table called "jointime" as in your original query. Please check your table definition. Hint:
Code:
mysql> select joindate from user where userid =1;
+-----------+
| joindate |
+-----------+
| 968947200 |
+-----------+
1 row in set (0.00 sec)
Today I mapped out the new badging system using FA icons, Beta 1 in no particular order except a 6 x 8 grid:
https://www.unix.com/members/1-albums215-picture991.png
The prototype HTML code for this layout:
<style>
.fa-badge-grid {
font-size: 1.5em;
}
.row {
... (38 Replies)
Dear All,
Here is the current status of the badging system:
The Beta 1 phase of the new badging system is close to completion.
42 prototype badges have been "allocated"
6 prototype badge slots are held in reserve
The "alert you have new badges" prototype is running and is currently... (4 Replies)
I have moved the bug badge out of reserve and into the main stream. Basically, I will assign a color level like the others, based on who has made a good actionable bug report for UNIX.COM. "Good" means screenshots, links, and even details from web dev tools our the HTML source code. So far,... (0 Replies)
Discussion started by: Neo
0 Replies
LEARN ABOUT SUSE
alevt-date
ALEVT-DATE(1) Teletext time ALEVT-DATE(1)NAME
alevt-date - display/set time received via Teletext
SYNOPSIS
alevt-date [options]
DESCRIPTION
alevt-date displays the time received from a Teletext source. It can be used to set the system time. The date is not interpreted (not
even transmitted on most channels). So it allows only adjustment of +/-12 hours. The default allowed adjustment is limited to +/-2 hours
(use -delta to change). Without the -set option it just displays the date in the format of the date(1) command.
OPTIONS
A summary of options is included below.
-set Set system time from time received via Teletext.
-delta seconds Maximum allowed adjustment made to the system time. The default is 7200 seconds (2 hours) and the maximum that may be
given is 12 hours.
-format string Format string to used to print the time. Look at strftime(3) for possible control sequences.
-vbi device Use the given device name (default: /dev/vbi0).
-timeout seconds If the time can't be detected in seconds, the program is terminated with a SIGALRM.
--help Show summary of options.
--version Show version of program.
Before starting this program, you have to set the TV channel with another program like xawtv of set-tv.
Note: This program does not set the battery backed up clock of your computer. clock -w will do this.
FILES
/dev/vbi*
SEE ALSO alevt(1x), alevt-cap(1), strftime(3), date(1), clock(8).
BUGS
This program is just a toy. The time transmitted by the TV stations is more than inaccurate. Some are within a few seconds of your local
time reference but others are more then 15 minutes off. You've been warned. (And don't assume the pkt8/30 time is better. It's even
worse.)
No bug reports to <froese@gmx.de> *g*.
LINUX 1.6.2 ALEVT-DATE(1)
01-01-2019
