Ask Question
Ask a Question
Ask Question Login
Gen AI
All Gen AIGen AIAgentic AI
AI & Machine Learning
All AI & Machine LearningAI Master TrainingData ScienceData EngineeringPython Master TrainingMachine Learning Master TrainingDeep Learning TableauData Science Certification Training using RData Visualization
Cloud Computing
All Cloud ComputingAWSAWS SysOpsAWS DeveloperMicrosoft Azure Solution ArchitectVMware
Salesforce Cloud
All Salesforce CloudSalesforceSalesforce AdminSalesforce DeveloperSalesforce App BuilderSalesforce LightningSalesforce Service Cloud
Cyber Security
All Cyber Security Cyber SecurityCompTIA security+CISSPCEH - Master
QA Testing
All QA TestingAI in Automation TestingQASelenium Testing Manual Testing Training & CertificationAutomation Testing TrainingPerformance TestingQTP/UFTAppium Certification Training
Business Analyst
All Business AnalystBusiness AnalystPMPSix SigmaScrum Master
Data Management
All Data ManagementSQL (Power BI)MS SQL ServerMSBISQL DBA Training TableauData AnalyticsOracle DBAHadoop
DevOps Master
All DevOps MasterDevOps
Data Science
Business Intelligence
All Business Intelligence TableauMSBITableau Admin
Digital Marketing
All Digital MarketingDigital MarketingSMO
Programming
All ProgrammingJava.NETPython Master TrainingiOS Android App DevelopmentRPA BlockchainFull Stack Developer
Self-learning
All Self-learning Cybersecurity Self LearningAWS Self-LearningSQL Server Self-LearningBusiness Analyst Self-LearningQA Self-LearningSalesforce Self-LearningTableau Self-LearningData Science Self-LearningiOS Self learningDevOps Self-Learning
Corporate Training
  1. Community
  2. Data Science
  3. Question
Data Science

How to return only the Date from a SQL Server DateTime datatype

Asked by Carl Paige Jul 5, 2021 845 views 1 answer
Share

About this question

SELECT GETDATE()

Returns: 

2008-09-22 15:24:13.790

I want that date part without the time part: 

2008-09-22 00:00:00.000

How can I get sql date only?

Your answer

1 Answer

More Data Science discussions

How to change font size of text and axes on R plots 4 answers · 37.2K views Difference between git stash pop and git stash apply 3 answers · 31.5K views git merge error: you need to resolve your current index first 2 answers · 23.3K views Test 29-04-2022 1 answer · 16.1K views How to resolve the error- found input variables with inconsistent numbers of samples? 3 answers · 11.5K views git list tracked files - how can I make git show a list of the files that are being tracked? 3 answers · 11.2K views

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.

Data Science Tutorials

Step-by-step Data Science guides from industry experts

  1. What is Model Evaluation and Selection in Data Mining? Data Science 12.5K reads
  2. Basic Statistical Descriptions of Data in Data Mining Data Science 12.5K reads
  3. What is Multidimensional and Mutltilevel Association Rule in Data Mining? Data Science 12.1K reads
  4. Rule-Based Classification in Data Mining Data Science 12.0K reads
  5. What is Constraint-Based Frequent Pattern Mining? Data Science 11.9K reads
  6. What is Data Discretization? Data Science 11.8K reads
Browse all tutorials →

Data Science Interview Q&A

Common Data Science interview questions, answered

  1. Statistics Interview Question and Answers Data Science 4.0K views
  2. Data Warehouse Interview Question And Answers in 2024 Data Science 3.4K views
  3. Linear Algebra Interview Questions and Answers for Beginners and Advanced Data Science 3.1K views
  4. Scikit-Learn Interview Questions You Must Know [With Sample Answers] Data Science 3.0K views
  5. R Programming Language Interview Questions & Answers Data Science 2.8K views
  6. Data Visualization Interview Questions and Answers Data Science 2.5K views
Browse all interview Q&A →

Latest Data Science Blogs

Guides, tips and career advice on Data Science from JanBask experts.

Data Science The Best Data Science Projects (Beginner To Advanced) Discover 15 data science project ideas from beginner to advanced levels. Includes tech stacks, time estimates, & real-use cases.… Aug 7, 2025 · 7.5K reads Read more → Data Science Data Science vs Software Engineering - What you should know? Compare Data Science vs. Software Engineering - explore skills, tools, roles, salaries, and career scope. Discover which tech… Jul 18, 2025 · 310.8K reads Read more → Data Science Top 15 Deep Learning Algorithms You Must Know in 2025 Discover the top 15 deep learning algorithms powering AI in 2025. Learn how deep learning models, DL models, and deep machine… Mar 25, 2025 · 2.2K reads Read more → Data Science Deep Learning Tutorial Guide for Beginners Deep Learning, Machine Learning & Artificial Intelligence have become trending words of the IT sector today. Mar 21, 2025 · 6.7K reads Read more →
View all Data Science blogs →