Skip to main content
ITCanopy

ITCanopy

  • Home
  • Terms of Use
  • Privacy Policy
  • Disclaimer
  • About
  • YouTube Channel
  • Facebook Page
  • Daraz Store

How to convert date difference into years in SQL

March 05, 2019 • คtเŦ
Add below in your SQL query and it will get date difference and convert into years: (DATEDIFF(MONTH,TABLE.BIRTH_DT,CURRENT_TIMESTAMP)/12...
Read More →

How to convert date difference into days in SQL

March 05, 2019 • คtเŦ
Add below in your SQL query and it will subtract date column from today's date and convert into days: CONVERT(INT, GETDATE() - TA...
Read More →
← Older Posts Home

Search This Blog

Translate

Tools

  • Visual Studio
  • Android Studio
  • Siebel CRM
  • Anaconda
  • Oracle BI Publisher
  • Database
  • Oracle
  • Microsoft SQL Server
  • Oracle SQL Developer
  • UiPath
  • RPA
  • Orchestrator
  • Internet Information Services Manager
  • SoapUI
  • Microsoft 365
  • Command Interpreter (CMD)
  • VMware
  • ffmpeg
  • Rufus
  • Antivirus
  • Windows PowerShell
  • Weblogic FMW

Programming Language

  • Programming Language
  • Java
  • ASP.NET
  • Python
  • Python 3
  • SQL
  • eScript
  • Kotlin

Operating System

  • Windows 7
  • Windows
  • Linux
  • Ubuntu
  • Pop!_OS

Online Tools

  • Tool

NEWS

  • NEWS
  • Movies
  • TV Series
  • Games

How To

  • How To
  • Knowledgebase
  • Blogger
  • PSX
  • PSX Historical Data
  • Review
  • Text Art
© ITCanopy by MainStay