search

Home >Database >Mysql Tutorial >判断一个日期是否为月末

判断一个日期是否为月末

WBOY
WBOYOriginal
2016-06-07 14:56:372827browse

判断一个日期是否为月末 无 DECLARE @Dt DATETIME SET @Dt = '2011-06-30'IF MONTH(@Dt) != MONTH(DATEADD(DAY,1,@Dt)) PRINT 'End Of Month'

判断一个日期是否为月末 
DECLARE @Dt DATETIME 
SET @Dt = '2011-06-30'
IF MONTH(@Dt) != MONTH(DATEADD(DAY,1,@Dt))
    PRINT 'End Of Month'
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：输出字符串“SQL Server 2008”中的每一个字符及其ASCII值。Next article：SQL*Plus常用指令

Related articles

See more