How to select day from timestamp in mysql?

R

R

Roman Kuzmenko2017-06-18 10:58:22

MySQL

Roman Kuzmenko, 2017-06-18 10:58:22

How to select day from timestamp in mysql?

Hello!
How to correctly select a day from mysql timestamp, but so that the value is two-digit, for example 01.02,...11 , if you use day(mydate) it outputs in the format 1,2,3, etc.

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

I

idShura, 2017-06-18
@devrvk

You can for example use DATE_FORMAT
select DATE_FORMAT('2017-06-03', '%d') from dual

Similar questions

V

Valera2014-04-26 21:12:14

Is the curriculum for teaching PL "from scratch" suitable? 5Reply

S

sugadu2016-07-17 14:24:45

How to catch url change in Component Router? 1Reply

T

todoman2022-02-10 13:46:35

Excel: How to make autocomplete from duplicate but incrementing dates? 1Reply

P

Persotr272020-10-15 02:32:44

How to bundle a Node + React app into a shared Workspace? 5Reply

G

gargamel12021-04-18 00:54:18

Working with multiple telebot keyboards? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question