在SQL Server中获取当前日期？ [英] Getting the current date in SQL Server?

问题描述

如何获取MS-SQL Server 2008 R2中的当前日期？

How can I get the current date in MS-SQL Server 2008 R2?

数据库中列的格式为 DATETIME 和日期以以下格式存储：

The format of the column in my database is DATETIME and dates are stored in the following format:

+++++++++++++ Vrdate ++++++++++
|                             |
|   2012-11-18 00:00:00.000   |
|   2012-11-19 00:00:00.000   |
|   2013-11-18 00:00:00.000   |
|   2012-12-01 00:00:00.000   |
|   2010-10-09 00:00:00.000   |
|   2012-11-11 00:00:00.000   |
|                             |
+++++++++++++++++++++++++++++++

我进行了搜索，但是找不到以这种格式获取日期的方法（即，与时间相关的时间在 00中： 00：00.00 ）。我找到了 GETDATE（）函数，但是它还提供了当前时间以及日期，我想要的是用以下格式获取日期： CurrentDate 00：00：00.00

I searched but wasn't able to find the way to get the date in this format (i.e. which has the time associated with it in 00:00:00.00). I found GETDATE() function but that provides the current time along with the date as well, what I want is get the date in the following format: CurrentDate 00:00:00.00

我怎么能得到这个？

推荐答案

SELECT CAST(GETDATE() AS DATE)

返回删除了时间部分的当前日期。

Returns the current date with the time part removed.

DATETIME 不存储以以下格式。它们以二进制格式存储。

DATETIMEs are not "stored in the following format". They are stored in a binary format.

SELECT CAST(GETDATE() AS BINARY(8))

问题中的显示格式与存储无关。

The display format in the question is independent of storage.

应将其格式化为特定的显示格式根据您的应用。

Formatting into a particular display format should be done by your application.

这篇关于在SQL Server中获取当前日期？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！