获取分钟秒和毫秒 [英] Fetch Minute second and millisecond
本文介绍了获取分钟秒和毫秒的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨朋友
i希望在sql server 2005中的getdate()函数中获取分钟秒毫秒请帮助我朋友
解决方案
< pre lang =sql> SQL Server 2008
SELECT
CONVERT ( TIME ,GETDATE()) AS HourMinuteSecond,
SQL Server 2000/2005
SELECT
CONVERT (< span class =code-keyword> VARCHAR ( 8 ),GETDATE(), 108 ) AS HourMinuteSecond,
http://blog.sqlauthority.com/2009/08/06/sql-server-get-time-in-hourminute-format-from-a-datetime-get-date-part -only-from-datetime / [ ^ ]
运行此查询以获取不同的结果:
SELECT CONVERT ( time ,SYSDATETIME())
, CONVERT ( time ,SYSDATETIMEOFFSET())
, CONVERT (时间,SYSUTCDATETIME())
, CONVERT ( time , CURRENT_TIMESTAMP )
, CONVERT ( 时间,GETDATE())
, CONVERT (时间,GETUTCDATE());
hi friends
i want to fetch minute second millisecond in getdate() function in sql server 2005 pls help me friends
解决方案
SQL Server 2008 SELECT CONVERT(TIME,GETDATE()) AS HourMinuteSecond,
SQL Server 2000/2005 SELECT CONVERT(VARCHAR(8),GETDATE(),108) AS HourMinuteSecond,
Hi,
http://blog.sqlauthority.com/2009/08/06/sql-server-get-time-in-hourminute-format-from-a-datetime-get-date-part-only-from-datetime/[^]
Run this query to get the different results:
SELECT CONVERT (time, SYSDATETIME()) ,CONVERT (time, SYSDATETIMEOFFSET()) ,CONVERT (time, SYSUTCDATETIME()) ,CONVERT (time, CURRENT_TIMESTAMP) ,CONVERT (time, GETDATE()) ,CONVERT (time, GETUTCDATE());
这篇关于获取分钟秒和毫秒的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文