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":0},"categories":[1],"tags":[797,4843,76],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/5302"}],"collection":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/comments?post=5302"}],"version-history":[{"count":0,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/5302\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/media?parent=5302"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/categories?post=5302"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/tags?post=5302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}