Hi all,<\/p>\n
Here is a simple function that can allow you to clear time from the DATETIME field of your database table<\/p>\n
[sql]
\nDROP FUNCTION IF EXISTS cleartime;
\ndelimiter \/\/
\nCREATE FUNCTION cleartime(dt datetime) RETURNS DATETIME
\n NO SQL
\n DETERMINISTIC
\nBEGIN
\n DECLARE t varchar(15); — the time part of the dt
\n DECLARE rdt datetime default dt; \t — the datetime after time part is cleared<\/p>\n
SET t = TIME(dt);
\n SET rdt = SUBTIME(dt,t);<\/p>\n
RETURN rdt;
\nEND \/\/
\ndelimiter ;
\n[\/sql]<\/p>\n
To import this function to your database just copy and paste above code in MySQL command prompt with your database selected.<\/p>\n
The implementation is shown in following example:<\/p>\n
[sql]
\nselect cleartime(datetime_field) from table_name; — to view field with its time cleared
\n –OR
\nupdate table_name set datetime_field=cleartime(datetime_feild) from table_name;
\n[\/sql]<\/p>\n","protected":false},"excerpt":{"rendered":"
Hi all, Here is a simple function that can allow you to clear time from the DATETIME field of your database table [sql] DROP FUNCTION IF EXISTS cleartime; delimiter \/\/ CREATE FUNCTION cleartime(dt datetime) RETURNS DATETIME NO SQL DETERMINISTIC BEGIN DECLARE t varchar(15); — the time part of the dt DECLARE rdt datetime default dt; […]<\/p>\n","protected":false},"author":39,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":6,"footnotes":""},"categories":[1],"tags":[797,4843,76],"class_list":["post-5302","post","type-post","status-publish","format-standard","hentry","category-technology","tag-clear-time","tag-database","tag-mysql"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t