CoderRaj

Tutorial King

MySQL

How to select only date from a DATETIME Field in MySql ?

ByCoderRaj

Dec 7, 2022

Example:- Data on database column just like 30-12-2022 01:14:41

Now you want to only date so you run below query

select DATE_FORMAT(date_of_birth,'%d-%m-%Y') from tbl_student
Post Views: 234

By CoderRaj

Related Post

MySQL

Create a MySQL User with Correct Permissions

Sep 13, 2024 CoderRaj
MySQL

How to Get row from mysql based on the sequence of values in the WHERE IN

Mar 23, 2023 CoderRaj
MySQL

How add days , month or year from any date in MySql

Feb 16, 2023 CoderRaj

You missed

MySQL

Create a MySQL User with Correct Permissions

Sep 13, 2024 CoderRaj
CodeIgniter PHP

CRUD operation using CodeIgniter

Jul 22, 2024 CoderRaj
ASP.Net

Use ToolTip inside asp.net GridView

May 7, 2024 CoderRaj
ASP.Net

Dynamically Change GridView data background color based on condition using C# asp.net

May 4, 2024 CoderRaj