Skip to content
Haneef Puttur
  • Windows.
    • ASP.Net C#
    • MVC
  • Open Source
    • Android.
    • Unix.
    • XENSERVER
    • Apple.
    • WordPress.
    • WordPress Theme
    • Portable WordPress
    • Endian Firewall
    • FreeNas
  • General.
    • C++
    • Arduino
    • Amazon
    • Blackberry
    • Sharepoint
    • SQL
    • Oracle
  • Windows.
    • ASP.Net C#
    • MVC
  • Open Source
    • Android.
    • Unix.
    • XENSERVER
    • Apple.
    • WordPress.
    • WordPress Theme
    • Portable WordPress
    • Endian Firewall
    • FreeNas
  • General.
    • C++
    • Arduino
    • Amazon
    • Blackberry
    • Sharepoint
    • SQL
    • Oracle
  • facebook.com
  • twitter.com
  • t.me
  • instagram.com
  • youtube.com
Subscribe
  • Home
  • Extract only date from mysql datetime column in mysql
Posted inMySQL Unix

Extract only date from mysql datetime column in mysql

Posted by By Haneef Puttur April 29, 2014No Comments

Problem :

Mysql database has datetime field and i want to get only date. 

Solution :

SELECT CAST(`datetime_field` AS DATE) AS dateonly FROM etc….

Haneef Puttur
View All Posts

Post navigation

Previous Post
How to Set Expiry Date for particular Category in OSclassifieds
Next Post
Dynamic Footer Copyright Year using php
Recent Comments
  • TinyMCE And Uploadify Integration ASP.NET MVC C# | Nikkies Tutorials on Step by Step Instruction – Integrate TinyMCE with Uploadify using ASP.Net MVC C#
  • ವೆಬ್ ಸೈಟ್ ಗೈಡ್: ವೆರ್ಡ್ ಪ್ರೆಸ್ ಕಲಿಯಲು ಆಫ್ ಲೈನ್ ಟೂಲ್ | ಕರ್ನಾಟಕ Best on Portable WordPress – Run without installation
  • ವರ್ಡ್ ಪ್ರೆಸ್: ಸ್ವಂತ ವೆಬ್ ಸೈಟ್ ನೀವೇ ನಿರ್ಮಿಸಿಕೊಳ್ಳಿ – KarnatakaBest.Com on Portable WordPress – Run without installation
  • Step by Step Instruction – Integrate TinyMCE with Uploadify using ASP.Net MVC C# - My CMS on Step by Step Instruction – Integrate TinyMCE with Uploadify using ASP.Net MVC C#
  • SignalR & Oracle DB Change Notification [Part 2 of 2] - Haneef Puttur on SignalR – Real-time web communication between Client and Server Easy c# [Part 1 of 2]
  • Amazon
  • Android
  • Antivirus
  • Apple
  • Arduino
  • ASP.Net
  • Audio Class
  • Blackberry
  • C#
  • C++
  • ChatGPT
  • Domains
  • Free Software
  • General
  • Internet
  • Kannada
  • Leaflet
  • mautic
  • MVC
  • MySQL
  • NodeJs
  • Oracle
  • OSClass
  • Premium Domains
  • Python
  • Sharepoint
  • SQL
  • SQL Server
  • Unix
  • WeBid
  • Windows
  • Wordpress
  • BME 280 – Node MCU Weather Station
  • AWS Ec2 Modify Volume Size
  • Super Moon Pics taken by Samsung S21 Ultra (SM-G998B)
  • Batch convert PDF to WORD using Python
  • Create a private ChatGPT with own documents
Copyright 2025 — Haneef Puttur. All rights reserved. Bloglo WordPress Theme
Scroll to Top