阅读背景:

使用查询SQL Server 2005选择DATEADD分钟

来源:互联网 
SELECT
   [NAMENO],
   [FIRSTNAME],
   [MIDNAME],
   [LASTNAME],
   [SEX],
   [STATUSOF],
   [RELEASEDT],
   CONVERT(VARCHAR(10), DOBDT, 101) AS DOBDT 
FROM
   database
WHERE 
   ReleaseDT >= dateadd(minute,datediff(minute,60,GETDATE()),0)
   AND ReleaseDT < dateadd(minute,datediff(minute,0,GETDATE()),0)
SELECT
   [NAMENO],
   [FIRSTNAME],
   [MIDNAME



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: