MySQL DATE_FORMAT() Function

-

MySQL DATE_FORMAT() Function

Example

Format a date:
SELECT DATE_FORMAT("2017-06-15", "%Y");
Try it Yourself »

Definition and Usage

The DATE_FORMAT() function formats a date as specified.

Syntax

DATE_FORMAT(date, format)
Resource: https://www.w3schools.com/sql/func_mysql_date_format.asp

Comments

  1. Blog27999March 6, 2020 at 1:05 AM

    If you're trying to lose pounds then you have to jump on this totally brand new tailor-made keto diet.

    To create this keto diet, certified nutritionists, fitness trainers, and professional cooks united to develop keto meal plans that are efficient, convenient, money-efficient, and delicious.

    Since their grand opening in 2019, 100's of people have already completely transformed their body and well-being with the benefits a great keto diet can provide.

    Speaking of benefits; in this link, you'll discover eight scientifically-certified ones offered by the keto diet.

    ReplyDelete
  2. w3spointSeptember 25, 2020 at 8:07 PM

    It was such a good post. Visit Oracle Tutorial. Thanks for sharing.

    ReplyDelete
  3. AbhiApril 9, 2021 at 7:09 PM

    How to generate error log file in PHP
    PHP SplFileObject Examples
    How to Encrypt And Decrypt String in PHP7
    Password Hashing PHP 7
    PHP7.3 New Features
    Get Visitor Details Using PHP And HTML
    Random password generator PHP
    PHP Graphics tutorial
    Secure passwords with PHP

    ReplyDelete

Post a Comment

Popular posts from this blog

Lab Network 2024

-
lab Module packet tracer https://myunitechsolution.com/nextcloud/index.php/s/PdenqfpLC9pag6i  Lab 3 https://docs.google.com/document/d/1wKePW0TcMn9LZL26o3_PGHxIEzuzelM5/edit?usp=sharing&ouid=110453821467437517477&rtpof=true&sd=true Lab 4 https://docs.google.com/document/d/1QshyTizoKUSwpsn6w9T7fMYAFzT7cajT/edit?usp=drivesdk&ouid=110453821467437517477&rtpof=true&sd=true  Lab5 https://drive.google.com/drive/folders/1H5e3LTKdx9rEDSrsuSewG67-Svrz35KP?usp=sharing Lab6 (lab module 7) https://myunitechsolution.com/nextcloud/index.php/s/bSeSZepBNTo6paY Lab7(lab module 6) https://myunitechsolution.com/nextcloud/index.php/s/43JmgCTy9xBYo2z Lab8 https://myunitechsolution.com/nextcloud/index.php/s/2ag95R7kiT6FTt2 Lab9 https://myunitechsolution.com/nextcloud/index.php/s/GCDw5Bnc5j95sfg Link to download Putty Download PuTTY - a free SSH and telnet client for Windows Driver serial to usb https://www.prolific.com.tw/US/ShowProduct.aspx?p_id=223&pcid=126 *install  PL23XX-M_Lo
Read more

Step to publish your static html web page to GitHub

-
  If you're looking to share your static website with the world, GitHub provides a simple and free solution through GitHub Pages. This guide will walk you through the process of deploying your static site on GitHub, making it accessible to anyone with an internet connection. GitHub Pages allows you to host static HTML, CSS, and JavaScript files directly from your GitHub repository. Whether you're showcasing a portfolio, documentation, or a personal project, GitHub Pages streamlines the deployment process. Follow the steps outlined in this guide to set up your GitHub repository, choose a publishing source, and configure your static site for seamless deployment. With just a few clicks, you'll have your static web page live and accessible on the web. click this link to download the guidelines Step to publish your static html web page to GitHub .pdf Link
Read more

Tutorial OOP(reversion java)

-
Reversion exercise for java. Please answer all questions in paper. Without using IDE. 30 minutes is allocate for this exercise. Get the questions in the link below. Java Reversion Exercise emailkan ke: arizalshamsil89@gmail.com subject: OOPReversion(no Matrik)
Read more