TIME_FORMAT

MySQL TIME_FORMAT() funksiyasi

❮ MySQL funksiyalari

Vaqtni formatlash:

SELECT TIME_FORMAT("19:30:10", "%H %i %s");

TIME_FORMAT() funksiyasi vaqtni belgilangan format bo‘yicha formatlaydi.

TIME_FORMAT(time, format)

Parametr

Tavsif

time

Majburiy. Formatlash vaqti

format

Required. The format to use. Can be one or a combination of the following:

Format	Tavsif
%f	Mikrosoniyalar (000000 dan 999999 gacha)
%H	Soat (00 dan 23 gacha)
%h	Soat (00 dan 12 gacha)
%I	Soat (00 dan 12 gacha)
%i	Daqiqalar (00 dan 59 gacha)
%p	AM yoki PM
%r	Vaqt 12 soat AM yoki PM formatida (ss:dd:ss AM/PM)
%S	soniyalar (00 dan 59 gacha)
%s	soniyalar (00 dan 59 gacha)
%T	24 soat formatidagi vaqt (ss:dd:ss)