{"id":128,"date":"2018-02-14T00:28:00","date_gmt":"2018-02-14T00:28:00","guid":{"rendered":"http:\/\/basicwebsitesolutions.com\/blog\/?p=128"},"modified":"2018-02-14T00:28:00","modified_gmt":"2018-02-14T00:28:00","slug":"interbase-how-to-get-the-weekday-month-year-and-day-from-timestamp","status":"publish","type":"post","link":"https:\/\/basicwebsitesolutions.com\/blog\/2018\/02\/14\/interbase-how-to-get-the-weekday-month-year-and-day-from-timestamp\/","title":{"rendered":"Interbase : How to get the weekday , month, year and day from timestamp"},"content":{"rendered":"

its amazing that a lot of the functions needed in our daily lives get embedded to a lot of software’s out there.<\/p>\n

This is a case that i needed to generate employees who went in on Monday. I was able to dig out these great finds.<\/p>\n

Enjoy<\/p>\n

Coffee Cup<\/p>\n

 <\/p>\n

The data type of\u00a0EXTRACT<\/span>(<\/span>)<\/span><\/span>\u00a0expressions depends on the specific part being extracted:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
Extract<\/th>\nResulting
\ndata type<\/th>\n		Representing<\/th>\n<\/tr>\n
YEAR<\/span><\/span><\/td>\nSMALLINT<\/span><\/span><\/td>\nYear, range 0-5400<\/td>\n<\/tr>\n
MONTH<\/span><\/span><\/td>\nSMALLINT<\/span><\/span><\/td>\nMonth, range 1-12<\/td>\n<\/tr>\n
DAY<\/span><\/span><\/td>\nSMALLINT<\/span><\/span><\/td>\nDay, range 1-31<\/td>\n<\/tr>\n
HOUR<\/span><\/span><\/td>\nSMALLINT<\/span><\/span><\/td>\nHour, range 1-23<\/td>\n<\/tr>\n
MINUTE<\/span><\/span><\/td>\nSMALLINT<\/span><\/span><\/td>\nMinute, range 1-59<\/td>\n<\/tr>\n
SECOND<\/span><\/span><\/td>\nDECIMAL<\/span>(<\/span>6<\/span>,<\/span>4<\/span>)<\/span><\/span><\/td>\nSecond, range 0-59.9999<\/td>\n<\/tr>\n
WEEKDAY<\/span><\/td>\nSMALLINT<\/span><\/span><\/td>\nDay of the week, range 0-6
\n(0 = Sunday, 1 = Monday, and so on)<\/td>\n<\/tr>\n
YEARDAY<\/span><\/td>\nSMALLINT<\/span><\/span><\/td>\nDay of the year, range 1-366<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
SELECT EXTRACT (YEAR FROM timestamp_fld) FROM table_name;\r\n=======\r\n1999\r\nSELECT EXTRACT (YEAR FROM timestamp_fld) FROM table_name;\r\n=======\r\n1999\r\nSELECT EXTRACT (MONTH FROM timestamp_fld) FROM table_name;\r\n=======\r\n6\r\nSELECT EXTRACT (DAY FROM timestamp_fld) FROM table_name;\r\n=======\r\n25\r\nSELECT EXTRACT (MINUTE FROM timestamp_fld) FROM table_name;\r\n=======\r\n24\r\nSELECT EXTRACT (SECOND FROM timestamp_fld) FROM table_name;\r\n============\r\n35.0000\r\nSELECT EXTRACT (WEEKDAY FROM timestamp_fld) FROM table_name;\r\n=======\r\n5\r\nSELECT EXTRACT (YEARDAY FROM timestamp_fld) FROM table_name;\r\n=======\r\n175\r\nSELECT EXTRACT (MONTH FROM timestamp_fld) ||\r\n'-' || EXTRACT (DAY FROM timestamp_fld) ||\r\n'-' || EXTRACT (YEAR FROM timestamp_fld) FROM table_name;\r\n====================\r\n6-25-1999<\/pre>\n
Source :\u00a0http:\/\/docwiki.embarcadero.com\/InterBase\/XE7\/en\/Extracting_Date_and_Time_Information<\/p>\n
 <\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
its amazing that a lot of the functions needed in our daily lives get embedded to a lot of software’s out there. This is a case that i needed to generate employees who went in on Monday. I was able to dig out these great finds. Enjoy Coffee Cup   The data type of\u00a0EXTRACT()\u00a0expressions depends … <\/p>\n
Continue reading “Interbase : How to get the weekday , month, year and day from timestamp”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-128","post","type-post","status-publish","format-standard","hentry","category-life-as-a-programmer"],"_links":{"self":[{"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/posts\/128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=128"}],"version-history":[{"count":1,"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/posts\/128\/revisions"}],"predecessor-version":[{"id":129,"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/posts\/128\/revisions\/129"}],"wp:attachment":[{"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=128"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}