CodeThatAint

Main menu

Skip to primary content

Skip to secondary content

Category Archives: Date Functions

Mysql Date Functions

Posted on July 11, 2012 by admin | Leave a reply

SELECT DATE_FORMAT(NOW(), ‘%d %b %Y’)

Output
11 Jul 2012

Other Formats

Posted in Date Functions.

Search

Categories

Util Commands (1)
Last Minute (3)
Intereview Questions (1)
Management (1)
- Team Building (1)
Devops (3)
- Azure (1)
Wiremock (1)
- Interview Questions (1)
Coding (2)
- Conditional Statements (2)
Security (12)
- JWT (3)
- Concepts (5)
- Java (3)
- Interview Questions (1)
UML (3)
Java 11 (1)
- Interview (1)
Test Driven Development(TDD) (1)
Threads (1)
Kafka (1)
Editors (1)
- Intellij (1)
Typescript (6)
- Modules (1)
- Casting (1)
- Interfaces (1)
- Functions (1)
- Interview Questions (1)
Cloud (3)
- Pivotal (2)
Mistakes and Learning (1)
Shell Scripting (1)
Angular (21)
- basics (2)
- Jasmine (4)
  - Errors and Warnings (1)
  - Mocking (1)
- Components and Databinding (2)
- Template Driven Forms (1)
- Services (2)
- Directives (3)
- Routing (1)
- Code Snippets (1)
- Code Examples (1)
- Interview Questions (3)
  - Queries (1)
Idioms and Phrases (1)
Maths (2)
- Logarithms (1)
Servers and Issues (2)
Logging (2)
- SLF4J (2)
Stock Market (1)
Automation Tools (10)
- Groovy (5)
- Jython (5)
  - Arrays (2)
  - File Handling (1)
Web Services (12)
- OpenAPI (2)
- REST (6)
  - Concepts (2)
- Interview Questions (1)
- SOAP (1)
Puzzles (3)
- Speed and Distance (1)
- Probability (1)
Algorithms (3)
- Basics (1)
- Search (1)
Big Data (19)
- Hadoop (4)
  - Commands (1)
  - File Formats (1)
- Hive (1)
- Interview Questions (7)
- Map Reduce (10)
- Pig (2)
Build Tools (19)
- Gradle (1)
  - Basics (1)
- ANT (3)
  - Errors and Warnings (1)
- Maven (14)
Business (7)
- Investments (4)
- Terminologies (3)
Cron Jobs (1)
CSS (1)
- Form Elements (1)
Database (51)
- Interview Questions (4)
- Data Migration (1)
- MySQL (11)
  - Date Functions (1)
  - Procedures (4)
  - Queries (1)
- Oracle (27)
  - Date (1)
  - Date Functions (1)
  - Errors (1)
  - Oracle Notes (4)
  - Packages & Procedures (4)
  - Queries (13)
    - Aggregate Functions (2)
- SQL (11)
Design Patterns (28)
- Antipattern (1)
- Creational Patterns (16)
  - Builder Pattern (2)
  - Prototype Pattern (1)
  - Abstract Factory Pattern (1)
  - Factory Pattern (6)
    - Static Factory Method (1)
    - Simple Factory (1)
  - Singleton Pattern (6)
- Structural Pattern (3)
  - Adapter Pattern (1)
  - Facade Pattern (1)
  - Decortator Pattern (1)
- Behavioural Patterns (2)
  - Strategy Pattern (1)
  - Observer Pattern (1)
- Data Access Object (1)
- Template Pattern (1)
- Visitor Pattern (1)
- Interview Questions (1)
Eclipse (5)
English (4)
- Grammar (1)
- Etiquette (2)
- vocabulary (1)
Excel (8)
Forms (2)
Gardening (6)
- Caring (1)
git (3)
Hindu Philosophy (1)
J2EE (6)
- Case Studies (1)
- Interview Questions (5)
Java (268)
- Memory Management (1)
- Java 8 (18)
  - Collections (1)
  - Concepts (3)
  - Interview Questions (3)
  - Streams (6)
    - Codes (3)
  - Lambdas (5)
- Core Java (1)
- Data Structures (1)
- Abstract (4)
- Access Modifiers (1)
- Arrays (8)
- Classes and Objects (9)
- codesnippet (2)
- Database (9)
- Date and Time (5)
- ENUM (1)
- Exceptions (3)
  - Interview Questions (2)
- File handling (2)
- Frameworks (80)
  - Spring Security (5)
    - Interview Questions (1)
  - Spring MVC (7)
    - Concepts (1)
    - Interview Questions (1)
  - Spring Boot (2)
    - Interview Questions (2)
  - JPA (8)
    - Interview Questions (3)
  - Hibernate (20)
    - Concepts (1)
    - Errors (2)
  - Spring (32)
    - Annotations (1)
    - AOP (3)
    - Data Binding (1)
    - Form Elements (6)
    - Interview (8)
    - MVC (4)
      - Controllers (2)
      - Resources (1)
    - Theory (5)
  - Struts2 (7)
    - Errors and Warnings (2)
    - Form Elements (2)
    - Iteration (2)
- Generics and Collections (13)
  - Tree (1)
  - Linked List (1)
  - HashMap (1)
  - Iterator (1)
  - List (4)
  - Set (1)
- Inner Classes (6)
- Interface (4)
- Interview Questions (28)
  - Programs and Solutions (3)
- Java Concepts (14)
- Java Pearls (3)
- JSON (1)
- JSP (12)
- Misc (5)
- Serialization (2)
- Servlets (17)
  - JSTL (2)
  - Sessions (3)
- Static and Final (4)
- Strings (3)
  - Interview Questions (2)
- Threads (13)
  - Reactive Programming (3)
  - Examples (1)
  - Basics (2)
  - Code Examples (3)
  - Concepts (1)
- Tools (1)
  - Findbug (1)
- Tweaks (1)
- Variables (3)
Javascript (35)
- JS (1)
- Frameworks (14)
  - RxJS (1)
  - Jquery (11)
  - Nodejs (2)
- Event Handling (1)
- Arrays (7)
- Checkbox (1)
- Date and Time (1)
- Form (1)
Misc (15)
- Travel (1)
Notepad++ (4)
Operating Systems (14)
- Linux (11)
  - CentOS (7)
  - Commands (2)
  - Ubuntu (1)
- Windows (3)
PHP (16)
- File Handling (2)
- Procedure Call (3)
- Smarty (1)
Sanatana dharma (1)
Servers (2)
- Tomcat (1)
- WAR (1)
Software Design (16)
- Methodologies (1)
- Effective Java (5)
- OOAD (1)
Strategy (5)
- Agile (1)
- Design thinking (3)
Testing (20)
- Integration Testing (2)
- Interview (1)
- Mockito (8)
  - Interview (2)
- mockmvc (1)
- Junit5 (3)
- JUnit (3)
  - Basics (1)
- Selenium (2)
  - xpath (1)
சைவம் (5)
படித்ததில் பிடித்தது (14)
- சிந்தனைகள் (2)
- திருக்குறள் (1)
பார்த்ததில் பிடித்தது (3)

November 2024
M	T	W	T	F	S	S
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30

« Oct

Search

Categories

Util Commands (1)
Last Minute (3)
Intereview Questions (1)
Management (1)
- Team Building (1)
Devops (3)
- Azure (1)
Wiremock (1)
- Interview Questions (1)
Coding (2)
- Conditional Statements (2)
Security (12)
- JWT (3)
- Concepts (5)
- Java (3)
- Interview Questions (1)
UML (3)
Java 11 (1)
- Interview (1)
Test Driven Development(TDD) (1)
Threads (1)
Kafka (1)
Editors (1)
- Intellij (1)
Typescript (6)
- Modules (1)
- Casting (1)
- Interfaces (1)
- Functions (1)
- Interview Questions (1)
Cloud (3)
- Pivotal (2)
Mistakes and Learning (1)
Shell Scripting (1)
Angular (21)
- basics (2)
- Jasmine (4)
  - Errors and Warnings (1)
  - Mocking (1)
- Components and Databinding (2)
- Template Driven Forms (1)
- Services (2)
- Directives (3)
- Routing (1)
- Code Snippets (1)
- Code Examples (1)
- Interview Questions (3)
  - Queries (1)
Idioms and Phrases (1)
Maths (2)
- Logarithms (1)
Servers and Issues (2)
Logging (2)
- SLF4J (2)
Stock Market (1)
Automation Tools (10)
- Groovy (5)
- Jython (5)
  - Arrays (2)
  - File Handling (1)
Web Services (12)
- OpenAPI (2)
- REST (6)
  - Concepts (2)
- Interview Questions (1)
- SOAP (1)
Puzzles (3)
- Speed and Distance (1)
- Probability (1)
Algorithms (3)
- Basics (1)
- Search (1)
Big Data (19)
- Hadoop (4)
  - Commands (1)
  - File Formats (1)
- Hive (1)
- Interview Questions (7)
- Map Reduce (10)
- Pig (2)
Build Tools (19)
- Gradle (1)
  - Basics (1)
- ANT (3)
  - Errors and Warnings (1)
- Maven (14)
Business (7)
- Investments (4)
- Terminologies (3)
Cron Jobs (1)
CSS (1)
- Form Elements (1)
Database (51)
- Interview Questions (4)
- Data Migration (1)
- MySQL (11)
  - Date Functions (1)
  - Procedures (4)
  - Queries (1)
- Oracle (27)
  - Date (1)
  - Date Functions (1)
  - Errors (1)
  - Oracle Notes (4)
  - Packages & Procedures (4)
  - Queries (13)
    - Aggregate Functions (2)
- SQL (11)
Design Patterns (28)
- Antipattern (1)
- Creational Patterns (16)
  - Builder Pattern (2)
  - Prototype Pattern (1)
  - Abstract Factory Pattern (1)
  - Factory Pattern (6)
    - Static Factory Method (1)
    - Simple Factory (1)
  - Singleton Pattern (6)
- Structural Pattern (3)
  - Adapter Pattern (1)
  - Facade Pattern (1)
  - Decortator Pattern (1)
- Behavioural Patterns (2)
  - Strategy Pattern (1)
  - Observer Pattern (1)
- Data Access Object (1)
- Template Pattern (1)
- Visitor Pattern (1)
- Interview Questions (1)
Eclipse (5)
English (4)
- Grammar (1)
- Etiquette (2)
- vocabulary (1)
Excel (8)
Forms (2)
Gardening (6)
- Caring (1)
git (3)
Hindu Philosophy (1)
J2EE (6)
- Case Studies (1)
- Interview Questions (5)
Java (268)
- Memory Management (1)
- Java 8 (18)
  - Collections (1)
  - Concepts (3)
  - Interview Questions (3)
  - Streams (6)
    - Codes (3)
  - Lambdas (5)
- Core Java (1)
- Data Structures (1)
- Abstract (4)
- Access Modifiers (1)
- Arrays (8)
- Classes and Objects (9)
- codesnippet (2)
- Database (9)
- Date and Time (5)
- ENUM (1)
- Exceptions (3)
  - Interview Questions (2)
- File handling (2)
- Frameworks (80)
  - Spring Security (5)
    - Interview Questions (1)
  - Spring MVC (7)
    - Concepts (1)
    - Interview Questions (1)
  - Spring Boot (2)
    - Interview Questions (2)
  - JPA (8)
    - Interview Questions (3)
  - Hibernate (20)
    - Concepts (1)
    - Errors (2)
  - Spring (32)
    - Annotations (1)
    - AOP (3)
    - Data Binding (1)
    - Form Elements (6)
    - Interview (8)
    - MVC (4)
      - Controllers (2)
      - Resources (1)
    - Theory (5)
  - Struts2 (7)
    - Errors and Warnings (2)
    - Form Elements (2)
    - Iteration (2)
- Generics and Collections (13)
  - Tree (1)
  - Linked List (1)
  - HashMap (1)
  - Iterator (1)
  - List (4)
  - Set (1)
- Inner Classes (6)
- Interface (4)
- Interview Questions (28)
  - Programs and Solutions (3)
- Java Concepts (14)
- Java Pearls (3)
- JSON (1)
- JSP (12)
- Misc (5)
- Serialization (2)
- Servlets (17)
  - JSTL (2)
  - Sessions (3)
- Static and Final (4)
- Strings (3)
  - Interview Questions (2)
- Threads (13)
  - Reactive Programming (3)
  - Examples (1)
  - Basics (2)
  - Code Examples (3)
  - Concepts (1)
- Tools (1)
  - Findbug (1)
- Tweaks (1)
- Variables (3)
Javascript (35)
- JS (1)
- Frameworks (14)
  - RxJS (1)
  - Jquery (11)
  - Nodejs (2)
- Event Handling (1)
- Arrays (7)
- Checkbox (1)
- Date and Time (1)
- Form (1)
Misc (15)
- Travel (1)
Notepad++ (4)
Operating Systems (14)
- Linux (11)
  - CentOS (7)
  - Commands (2)
  - Ubuntu (1)
- Windows (3)
PHP (16)
- File Handling (2)
- Procedure Call (3)
- Smarty (1)
Sanatana dharma (1)
Servers (2)
- Tomcat (1)
- WAR (1)
Software Design (16)
- Methodologies (1)
- Effective Java (5)
- OOAD (1)
Strategy (5)
- Agile (1)
- Design thinking (3)
Testing (20)
- Integration Testing (2)
- Interview (1)
- Mockito (8)
  - Interview (2)
- mockmvc (1)
- Junit5 (3)
- JUnit (3)
  - Basics (1)
- Selenium (2)
  - xpath (1)
சைவம் (5)
படித்ததில் பிடித்தது (14)
- சிந்தனைகள் (2)
- திருக்குறள் (1)
பார்த்ததில் பிடித்தது (3)

November 2024
M	T	W	T	F	S	S
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30

« Oct

Tags

annotations Effective Java english interview Minimalism Mockito services Whatsapp Java Group

© 2024 CodeThatAint, all rights reserved.

Proudly powered by WordPress