{"id":8487,"date":"2022-04-06T08:40:14","date_gmt":"2022-04-06T08:40:14","guid":{"rendered":"https:\/\/www.gologica.com\/elearning\/?p=8487"},"modified":"2025-04-07T12:08:14","modified_gmt":"2025-04-07T12:08:14","slug":"using-pl-sql-work-with-dates-and-timestamps","status":"publish","type":"post","link":"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/","title":{"rendered":"Using PL\/SQL Work with dates and timestamps"},"content":{"rendered":"<p>DATE and TIME values in PL\/SQL have an entire distinctive to have a proper utilization set of functions and operators. It is important to come across the date tools so that various queries deal with DATE and TIME information.<\/p>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.gologica.com\/elearning\/\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/Explore-Your-CurriculumLearning-New-Tech-Courses-1-1024x576.jpg\" alt=\"\" class=\"wp-image-8496\" srcset=\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/Explore-Your-CurriculumLearning-New-Tech-Courses-1-1024x576.jpg 1024w, https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/Explore-Your-CurriculumLearning-New-Tech-Courses-1-460x259.jpg 460w, https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/Explore-Your-CurriculumLearning-New-Tech-Courses-1-768x432.jpg 768w, https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/Explore-Your-CurriculumLearning-New-Tech-Courses-1-100x56.jpg 100w, https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/Explore-Your-CurriculumLearning-New-Tech-Courses-1-600x338.jpg 600w, https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/Explore-Your-CurriculumLearning-New-Tech-Courses-1-120x68.jpg 120w, https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/Explore-Your-CurriculumLearning-New-Tech-Courses-1-310x174.jpg 310w, https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/Explore-Your-CurriculumLearning-New-Tech-Courses-1.jpg 1920w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<h2 class=\"wp-block-heading\"><strong>PL SQL Date time Format<\/strong> <\/h2>\n<p><\/p>\n<p><a href=\"https:\/\/www.gologica.com\/course\/mysql-training\/\"><strong><em>PL\/SQL<\/em><\/strong><\/a> has a date\/time data type that allows us to hold and calculate dates, intervals, and times. The variable that is of type date or time contains a value called Date Time. The variable that keeps the interval data type is called the interval. Each of these data types has fields that set the value.<\/p>\n<\/p>\n<p>The Date-Time data types are as follows:<\/p>\n<\/p>\n<ul class=\"wp-block-list\">\n<li>DATE<\/li>\n<li>TIMESTAMP<\/li>\n<li>TIMESTAMP WITH TIME ZONE<\/li>\n<li>TIMESTAMP WITH LOCAL TIME ZONE<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"><strong>1. DATE<\/strong> <\/h2>\n<\/p>\n<p>The fixed-length date times are stored in the data type DATE. It comprises the time of the day from midnight in seconds. The date section points to the first day of the present month and the time section points to midnight. It holds date and time information in both number and character data types.<\/p>\n<\/p>\n<p>SYSDATE is a date function that fetches the present time and date. The character values in the default format which is determined by Oracle initialization parameter NLS_DATE_FORMAT and also they are converted naturally by PL\/SQL to DATE values. We can apply mathematical operations like addition and subtraction on dates. PL\/SQL interprets integer literals in the form of days. For example, SYSDATE + 1 point to tomorrow.<\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\"><strong>2. TIMESTAMP<\/strong> <\/h2>\n<\/p>\n<p>The timestamp data type is an extension of the DATE data type. It is used to hold the year, month, hour, and second. The default timestamp format is determined by the Oracle initialization parameter NLS_TIMESTAMP_FORMAT. Here, the precision is not a mandatory parameter and points to the count of the number of digits that is in the fractional part of the second&#8217;s field. The precision should be any integer literal from 0 to 9. The default value is set to 6.  Syntax: TIMESTAMP[(precision)]<\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\"><strong>3. TIMESTAMP WITH TIME ZONE<\/strong> <\/h2>\n<\/p>\n<p>This data type is an extension of the TIMESTAMP data type and contains time zone displacement. The time zone displacement is the time difference between hours and minutes within local time and Coordinated Universal Time (UTC). The default timestamp with time zone format is determined by Oracle initialization parameter NLS_TIMESTAMP_TZ_FORMAT. Syntax: TIMESTAMP[(precision)] WITH TIME ZONE.<\/p>\n<\/p>\n<p>Here the precision is not a mandatory parameter and points to the count of the number of digits that is in the fractional part of the second&#8217;s field. The precision should be any integer literal from 0 to 9. The default value is set to 6. We can mention the time zone with symbols. It can be of long-form like \u2018US\/Pacific\u2019 or in short like \u2018PDT\u2019 or a combination of both. Thus this data type is used for covering and computing information across geographic locations.<\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\"><strong>4. TIMESTAMP WITH LOCAL TIME ZONE<\/strong> <\/h2>\n<\/p>\n<p>Timestamp with local time zone data type is an extension of the TIMESTAMP data type and contains time zone displacement. The time zone displacement is the time difference (in hours and minutes) between local time and Coordinated Universal Time (UTC). Syntax: TIMESTAMP [(precision)] WITH LOCAL TIME ZONE<\/p>\n<\/p>\n<p>Here, the precision is not a mandatory parameter and points to the count of the number of digits that is in the fractional part of the second\u2019s field. The precision should be any integer literal from 0 to 9. The default value is set to 6. TIMESTAMP WITH LOCAL TIME ZONE is different from TIMESTAMP WITH TIME ZONE due to the fact that while we insert a value to the database, the value is set to the time zone of the database and the time zone displacement is not held in the database column. However, on fetching the value, it is returned in the local time zone session.<\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\"><strong>Following are The Interval data types:<\/strong> <\/h2>\n<\/p>\n<ul class=\"wp-block-list\">\n<li>INTERVAL DAY TO SECOND<\/li>\n<li>INTERVAL YEAR TO MONTH<\/li>\n<\/ul>\n<p><strong>1. INTERVAL YEAR TO SECOND<\/strong><\/p>\n<p>The Interval year to a second data type is used to store and compute days, hours, minutes, and second\u2019s intervals. Syntax: INTERVAL DAY [(l_precision)] TO SECOND [(fractional_s_precision)]<\/p>\n<\/p>\n<p>Here, the l_precision and fractional_s_precision are the count of the number of digits in the days and seconds field, respectively. The precision should be any integer literal from 0 to 9. The default values are set to 2 and 6 respectively.<\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\"><strong>2. INTERVAL YEAR TO MONTH<\/strong><br \/> <\/h2>\n<p>This data type is used to store and compute years and months intervals. Syntax: INTERVAL YEAR [(precision)] TO MONTH<\/p>\n<p>Here, precision is the count of the number of digits in a year\u2019s field. The precision should be any integer literal from 0 to 4. The default value is set to 2.<\/p>\n<p><\/p>\n<h2 class=\"wp-block-heading\"><strong>PL SQL Functions in Datetime<\/strong><br \/> <\/h2>\n<\/p>\n<p>Below are the functions and purpose of each value. Here, m and n contain the values of the DateTime.<\/p>\n<\/p>\n<ul class=\"wp-block-list\">\n<li>LAST_DAY (m) = Fetches the last day of the month.<\/li>\n<li>ADD_MONTHS (m,n) = Sums up m and n months.<\/li>\n<li>MONTHS_BETWEEN (m,n) = Fetches the count of the number of months in between m and n.<\/li>\n<li>NEXT_DAY (m, day) = Fetches the DateTime of the following day after m.<\/li>\n<li>NEXT_TIME = Fetches the time\/day from the user&#8217;s requested time zone.<\/li>\n<li>ROUND (m[,unit]) = Rounds m.<\/li>\n<li>SYSDATE () = Fetches the present datetime.<\/li>\n<li>TRUNC (m[,unit]) = Truncates m.<\/li>\n<\/ul>\n<\/p>\n<h2 class=\"wp-block-heading\"><strong>PL SQL Functions in Timestamp<\/strong><br \/> <\/h2>\n<p>Following are the functions and their respective purposes. Here, m contains the value of the timestamp.<\/p>\n<\/p>\n<ul class=\"wp-block-list\">\n<li>CURRENT_TIMESTAMP () = Fetches a TIMESTAMP WITH TIMEZONE having the present session and session time zone.<\/li>\n<li>FROM_TZ (m, time_zone) = Converts the m TIMESTAMP and mentions time_zone to TIMESTAMP WITH TIMEZONE.<\/li>\n<li>LOCALTIMESTAMP () = Fetches a TIMESTAMP having the local time in the session time zone.<\/li>\n<li>SYSTEMTIMESTAMP () = Fetches a TIMESTAMP WITH TIMEZONE having the present database time and database time zone.<\/li>\n<li>SYS_EXTRACT_UTC (m) = Converts the m TIMESTAMP WITH TIMEZONE to TIMESTAMP having date and time in UTC.<\/li>\n<li>TO_TIMESTAMP (m,[format]) = Converts the string m to a TIMESTAMP.<\/li>\n<li>TO_TIMESTAMP_TZ (m,[format]) = Converts the string m to a TIMESTAMP WITH TIMEZONE.<\/li>\n<\/ul>\n<\/p>\n<\/p>\n<\/p>\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.gologica.com\/\"><img decoding=\"async\" width=\"800\" height=\"175\" src=\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/Fastrack-Your-Career-Growth-with-Gologica-3.jpg\" alt=\"\" class=\"wp-image-8495\" srcset=\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/Fastrack-Your-Career-Growth-with-Gologica-3.jpg 800w, https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/Fastrack-Your-Career-Growth-with-Gologica-3-460x101.jpg 460w, https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/Fastrack-Your-Career-Growth-with-Gologica-3-768x168.jpg 768w, https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/Fastrack-Your-Career-Growth-with-Gologica-3-100x22.jpg 100w, https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/Fastrack-Your-Career-Growth-with-Gologica-3-600x131.jpg 600w, https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/Fastrack-Your-Career-Growth-with-Gologica-3-120x26.jpg 120w, https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/Fastrack-Your-Career-Growth-with-Gologica-3-310x68.jpg 310w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/figure>\n<\/p>\n<\/p>\n<\/p>\n<\/p>\n<h2 class=\"wp-block-heading\"><strong>Conclusion<\/strong><br \/> <\/h2>\n<\/p>\n<p>We have discussed few basic concepts of PL\/SQL Date and Time that are essential for using them in programming.<a href=\"https:\/\/www.gologica.com\/course\/oracle-plsql\/\"><strong><em> Oracle PLSQL Online Training<\/em><\/strong><\/a> Course at <a href=\"https:\/\/www.gologica.com\/\"><strong><em>Gologica<\/em><\/strong><\/a> furnishes you with the total abilities expected to make, execute and oversee strong database applications utilizing the Oracle database instruments. Upgrade your skills by applying the world&#8217;s Best Online Learning Platform. Happy Learning!!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DATE and TIME values in PL\/SQL have an entire distinctive to have a proper utilization set of functions and operators. &hellip;<\/p>\n","protected":false},"author":95,"featured_media":8494,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"pmpro_default_level":"","footnotes":""},"categories":[12],"tags":[276,308,819,831,364],"coauthors":[347],"class_list":["post-8487","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle_intervew_questions","tag-online-training","tag-oracle","tag-oracle-plsql","tag-plsql","tag-training","pmpro-has-access","user-has-not-earned"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Working with dates and time stamps in PL\/SQL | Gologica<\/title>\n<meta name=\"description\" content=\"Gologica provides MySQL Training course has been designed with a focus on quality and simplicity making it ideal for Beginners and also for those looking for a refresher in their career. It gives an engaging learning experience covering everything you need to know about working on MySQL and their Data sets.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Working with dates and time stamps in PL\/SQL | Gologica\" \/>\n<meta property=\"og:description\" content=\"Gologica provides MySQL Training course has been designed with a focus on quality and simplicity making it ideal for Beginners and also for those looking for a refresher in their career. It gives an engaging learning experience covering everything you need to know about working on MySQL and their Data sets.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/\" \/>\n<meta property=\"og:site_name\" content=\"GoLogica\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-06T08:40:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-07T12:08:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/LOOKING-TO-PURSUE-YOUR-DREAM-CAREER-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"175\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Kavya Sathvik\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kavya Sathvik\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/\"},\"author\":{\"name\":\"Kavya Sathvik\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/be751af3a5dfedf6e0cb1010412e58ff\"},\"headline\":\"Using PL\/SQL Work with dates and timestamps\",\"datePublished\":\"2022-04-06T08:40:14+00:00\",\"dateModified\":\"2025-04-07T12:08:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/\"},\"wordCount\":1067,\"image\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/LOOKING-TO-PURSUE-YOUR-DREAM-CAREER-1.jpg\",\"keywords\":[\"Online training\",\"Oracle\",\"oracle plsql\",\"plsql\",\"Training\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/\",\"url\":\"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/\",\"name\":\"Working with dates and time stamps in PL\/SQL | Gologica\",\"isPartOf\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/LOOKING-TO-PURSUE-YOUR-DREAM-CAREER-1.jpg\",\"datePublished\":\"2022-04-06T08:40:14+00:00\",\"dateModified\":\"2025-04-07T12:08:14+00:00\",\"author\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/be751af3a5dfedf6e0cb1010412e58ff\"},\"description\":\"Gologica provides MySQL Training course has been designed with a focus on quality and simplicity making it ideal for Beginners and also for those looking for a refresher in their career. It gives an engaging learning experience covering everything you need to know about working on MySQL and their Data sets.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/#primaryimage\",\"url\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/LOOKING-TO-PURSUE-YOUR-DREAM-CAREER-1.jpg\",\"contentUrl\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/LOOKING-TO-PURSUE-YOUR-DREAM-CAREER-1.jpg\",\"width\":300,\"height\":175},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.gologica.com\/elearning\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using PL\/SQL Work with dates and timestamps\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/#website\",\"url\":\"https:\/\/www.gologica.com\/elearning\/\",\"name\":\"GoLogica\",\"description\":\"E-Learning Portal\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.gologica.com\/elearning\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/be751af3a5dfedf6e0cb1010412e58ff\",\"name\":\"Kavya Sathvik\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/image\/6284dd535a9619a5b8003bfe2b3cf2af\",\"url\":\"https:\/\/lh3.googleusercontent.com\/a\/default-user=s96-c\",\"contentUrl\":\"https:\/\/lh3.googleusercontent.com\/a\/default-user=s96-c\",\"caption\":\"Kavya Sathvik\"},\"url\":\"https:\/\/www.gologica.com\/elearning\/author\/kavya5gologica\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Working with dates and time stamps in PL\/SQL | Gologica","description":"Gologica provides MySQL Training course has been designed with a focus on quality and simplicity making it ideal for Beginners and also for those looking for a refresher in their career. It gives an engaging learning experience covering everything you need to know about working on MySQL and their Data sets.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/","og_locale":"en_US","og_type":"article","og_title":"Working with dates and time stamps in PL\/SQL | Gologica","og_description":"Gologica provides MySQL Training course has been designed with a focus on quality and simplicity making it ideal for Beginners and also for those looking for a refresher in their career. It gives an engaging learning experience covering everything you need to know about working on MySQL and their Data sets.","og_url":"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/","og_site_name":"GoLogica","article_published_time":"2022-04-06T08:40:14+00:00","article_modified_time":"2025-04-07T12:08:14+00:00","og_image":[{"width":300,"height":175,"url":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/LOOKING-TO-PURSUE-YOUR-DREAM-CAREER-1.jpg","type":"image\/jpeg"}],"author":"Kavya Sathvik","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kavya Sathvik","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/#article","isPartOf":{"@id":"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/"},"author":{"name":"Kavya Sathvik","@id":"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/be751af3a5dfedf6e0cb1010412e58ff"},"headline":"Using PL\/SQL Work with dates and timestamps","datePublished":"2022-04-06T08:40:14+00:00","dateModified":"2025-04-07T12:08:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/"},"wordCount":1067,"image":{"@id":"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/LOOKING-TO-PURSUE-YOUR-DREAM-CAREER-1.jpg","keywords":["Online training","Oracle","oracle plsql","plsql","Training"],"articleSection":["Oracle"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/","url":"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/","name":"Working with dates and time stamps in PL\/SQL | Gologica","isPartOf":{"@id":"https:\/\/www.gologica.com\/elearning\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/#primaryimage"},"image":{"@id":"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/LOOKING-TO-PURSUE-YOUR-DREAM-CAREER-1.jpg","datePublished":"2022-04-06T08:40:14+00:00","dateModified":"2025-04-07T12:08:14+00:00","author":{"@id":"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/be751af3a5dfedf6e0cb1010412e58ff"},"description":"Gologica provides MySQL Training course has been designed with a focus on quality and simplicity making it ideal for Beginners and also for those looking for a refresher in their career. It gives an engaging learning experience covering everything you need to know about working on MySQL and their Data sets.","breadcrumb":{"@id":"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/#primaryimage","url":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/LOOKING-TO-PURSUE-YOUR-DREAM-CAREER-1.jpg","contentUrl":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2022\/04\/LOOKING-TO-PURSUE-YOUR-DREAM-CAREER-1.jpg","width":300,"height":175},{"@type":"BreadcrumbList","@id":"https:\/\/www.gologica.com\/elearning\/using-pl-sql-work-with-dates-and-timestamps\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.gologica.com\/elearning\/"},{"@type":"ListItem","position":2,"name":"Using PL\/SQL Work with dates and timestamps"}]},{"@type":"WebSite","@id":"https:\/\/www.gologica.com\/elearning\/#website","url":"https:\/\/www.gologica.com\/elearning\/","name":"GoLogica","description":"E-Learning Portal","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.gologica.com\/elearning\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/be751af3a5dfedf6e0cb1010412e58ff","name":"Kavya Sathvik","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/image\/6284dd535a9619a5b8003bfe2b3cf2af","url":"https:\/\/lh3.googleusercontent.com\/a\/default-user=s96-c","contentUrl":"https:\/\/lh3.googleusercontent.com\/a\/default-user=s96-c","caption":"Kavya Sathvik"},"url":"https:\/\/www.gologica.com\/elearning\/author\/kavya5gologica\/"}]}},"_links":{"self":[{"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/posts\/8487","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/users\/95"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/comments?post=8487"}],"version-history":[{"count":1,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/posts\/8487\/revisions"}],"predecessor-version":[{"id":8497,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/posts\/8487\/revisions\/8497"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/media\/8494"}],"wp:attachment":[{"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/media?parent=8487"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/categories?post=8487"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/tags?post=8487"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/coauthors?post=8487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}