My Computer Tips

My Computer Tips was launched in 2015 and provides information for common tasks in various Linux distributions and other computer related subjects.

My Computer tips has over 290 tutorials and tips.

If you found the information on My Computer Tips useful, please consider sharing our site details.

Valid CSS!

Categories

Amazon+Associates Amazon Associates (1)

Android Android (8)

Apps Apps (1)

Bash+Scripts Bash Scripts (4)

C%2B%2B C++ (4)

Cachyos Cachyos (2)

Caja+File+Manager Caja File Manager (2)

Cinnamon+Desktop Cinnamon Desktop (1)

Computer+Ramblings Computer Ramblings (17)

CPanel CPanel (1)

CSS CSS (7)

Cups+%28Common+UNIX+Printing+System%29 Cups (Common UNIX Printing System) (3)

Debian Debian (1)

Emulators Emulators (15)

Facebook Facebook (1)

Firefox Firefox (5)

Gnome3 Gnome3 (2)

Google Google (3)

Google+Chrome Google Chrome (2)

HTML HTML (5)

Image+Editors Image Editors (2)

Java Java (5)

Kubuntu Kubuntu (5)

Libre+Office+Draw Libre Office Draw (2)

Linux Linux (3)

Linux+Mint Linux Mint (4)

Linux+Terminal Linux Terminal (47)

Lubuntu Lubuntu (4)

MariaDB+Database MariaDB Database (10)

MySQL+Database MySQL Database (2)

PC+Components+%26+Maintenance PC Components & Maintenance (8)

PHP7 PHP7 (12)

Python3 Python3 (5)

Retro+Software%2C+Magazines+%26+Games Retro Software, Magazines & Games (12)

Search+Engines+%28SEO%29 Search Engines (SEO) (2)

SQlite SQlite (1)

Steam Steam (1)

Thunderbird+Email+Client Thunderbird Email Client (6)

Ubuntu Ubuntu (32)

Ubuntu+Mate Ubuntu Mate (15)

Vanilla+Javascript Vanilla Javascript (9)

Virtualization Virtualization (5)

Windows Windows (1)

Wine Wine (5)

Xubuntu Xubuntu (10)

Show Categories

Amazon+Associates Amazon Associates (1)

Android Android (8)

Apps Apps (1)

Bash+Scripts Bash Scripts (4)

C%2B%2B C++ (4)

Cachyos Cachyos (2)

Caja+File+Manager Caja File Manager (2)

Cinnamon+Desktop Cinnamon Desktop (1)

Computer+Ramblings Computer Ramblings (17)

CPanel CPanel (1)

CSS CSS (7)

Cups+%28Common+UNIX+Printing+System%29 Cups (Common UNIX Printing System) (3)

Debian Debian (1)

Emulators Emulators (15)

Facebook Facebook (1)

Firefox Firefox (5)

Gnome3 Gnome3 (2)

Google Google (3)

Google+Chrome Google Chrome (2)

HTML HTML (5)

Image+Editors Image Editors (2)

Java Java (5)

Kubuntu Kubuntu (5)

Libre+Office+Draw Libre Office Draw (2)

Linux Linux (3)

Linux+Mint Linux Mint (4)

Linux+Terminal Linux Terminal (47)

Lubuntu Lubuntu (4)

MariaDB+Database MariaDB Database (10)

MySQL+Database MySQL Database (2)

PC+Components+%26+Maintenance PC Components & Maintenance (8)

PHP7 PHP7 (12)

Python3 Python3 (5)

Retro+Software%2C+Magazines+%26+Games Retro Software, Magazines & Games (12)

Search+Engines+%28SEO%29 Search Engines (SEO) (2)

SQlite SQlite (1)

Steam Steam (1)

Thunderbird+Email+Client Thunderbird Email Client (6)

Ubuntu Ubuntu (32)

Ubuntu+Mate Ubuntu Mate (15)

Vanilla+Javascript Vanilla Javascript (9)

Virtualization Virtualization (5)

Windows Windows (1)

Wine Wine (5)

Xubuntu Xubuntu (10)

Convert unix timestamp in seconds to readable date in MySQL / MariaDB

ID: 368

Category: MariaDB Database

Added: 12th of January 2024

Views: 1,230



The following table has a list of users with the following fields:
user_id
registration_date
name
country



To convert the field registration_date in seconds to readable date in MySQL / MariaDB enter the following query

select user_id, FROM_UNIXTIME(registration_date, '%d/%m/%Y %h:%i:%s') as formatted_date, name, country from tbl_users_example ORDER BY registration_date ASC;




The operators to format the date
%d = Date
%m = Month
%Y = Year
%h = Hours
%i = Minutes
%s = Seconds

The date was set in UK Format. For US date format you would enter the following

select user_id, FROM_UNIXTIME(registration_date, '%m/%d/%Y %h:%i:%s') as formatted_date, name, country from tbl_users_example ORDER BY registration_date ASC;


Computer Parts For Sale.

Links

Linux Forums

Arch Linux Forums Arch Linux Forums

Fedora Forums Fedora Forums

Linux Mint Forums Linux Mint Forums

Linux Questions Forum Linux Questions Forum

Ubuntu Forums Ubuntu Forums

Linux Gaming

Gaming on Linux Gaming on Linux

ProtonDB ProtonDB

Steam Download Steam Download

Other Linux / Computer Sites

Big Box Collection Big Box Collection

Phoronix Phoronix

OMG Ubuntu OMG Ubuntu

Other Sites / Shopping

Amazon Computer Parts For Sale (UK Only)

Amazon Buy Google Play Vouchers (UK Only)

Amazon Amazon (UK Only)

Latest Linux News

Latest Linux News Linux 6.18 Will Be A Big Improvement For Servers Encountering DDoS Attacks - Phoronix
Published: October 3, 2025, 6:55 pm

Latest Linux News 7 unusual Linux distros built for one purpose (and why you should try them) - XDA
Published: October 4, 2025, 8:00 pm

Latest Linux News Raspberry Pi OS Is Now Based on Debian 13 “Trixie” with Fresh New Look - 9to5Linux
Published: October 2, 2025, 10:09 am

Latest Linux News I borrowed these habits from Linux and my Windows setup is better for it - MakeUseOf
Published: October 2, 2025, 9:00 pm

Latest Linux News F2FS Lands Performance Improvements In Linux 6.18 - Phoronix
Published: October 4, 2025, 1:09 pm

Latest Linux News Linux 6.18 Device Tree Prepares For Arm C1 Nano / Pro / Premium / Ultra CPUs - Phoronix
Published: October 3, 2025, 1:47 pm

Latest Linux News Intel NPU Linux Driver 1.24 Released - Phoronix
Published: October 3, 2025, 12:35 pm

Latest Linux News Haptic Touchpad Support Makes It Into Linux 6.18 - Phoronix
Published: October 5, 2025, 10:17 am

Latest Linux News Linux 6.18 DRM Pull Includes New Tyr & Rocket Drivers, More AMD & Intel GPU Enhancements - Phoronix
Published: October 5, 2025, 1:34 pm

Latest Linux News Linux 6.18 IOMMU Changes For Intel, AMD, Apple & RISC-V - Phoronix
Published: October 4, 2025, 9:55 am