❤ 💻 Dirask - IT community

#datetime - Questions and answers

3 questions, 1 pages, 20 questions on this page

Page size:

Sort by:

3 points

MySQL - How auto-complete datetime field value in MySQL Workbench?

How can I set DATETIME type row value autocomplete? I need default value to be automatically added when the row is created. I'm working with MySQL Workbench.

1 answers

518

6 points

MySQL - what is the difference between DATETIME and TIMESTAMP?

Both DATETIME and TIMESTAMP contain the date and time parts, so can you tell me what's the difference between them?

1 answers

327

0 points

MySQL - how to display date values without time?

I'm doing date comparison in MySQL and I want to display date values without time. Example: I want to have 2020-01-01 instead of 2020-01-01 00:00:00. How to get rid of the 00:00:00 part? My code:

1 answers