Skip to content

PowerCram Blog

POW·ER·CRAM NOUN, \ˈPAU̇(-Ə)R\ˈKRAM\ – CONSISE, USEFUL INFORMATION ABOUT COMPUTERS, NETWORKS AND CLOUD.

  • PowerCram
Contact Us
Type to Search
x
  • Home
  • getdate

Category: getdate

How to get only hour from getdate() function in sql server

Posted in getdate, Linux, SQL, WindowsLeave a Comment on How to get only hour from getdate() function in sql server

select datepart(hour,getdate()) as [hours] DatePart Function will retrieve part of the date. Syntax:DATEPART(part, datetime) Part—-Ms for MillisecondsYy for YearQq for Quarter of the YearMm for MonthDy for the Day of the YearDd for Day of the MonthWk for WeekDw for the Day of the WeekHh for HourMi for MinuteSs for Second You can replace part […]

How to get only hour from getdate() function in sql server Read More
Posted on November 19, 2009 By user

Recent

  • AWS Passes 2% of Available IPv4 Addresses
  • AWS EC2 Instance Types per Region or Local Zone
  • What is the Size and Scope of AWS Anyway?
  • Surviving an(other) AWS Outage – US-West-2 Outage 8/31/2021
  • End of an Era – EC2-Classic Retiring

Recent Comments

  • historypak on Download mp3 (music) files with wget
  • PCA on Use PowerShell to Save Excel Worksheet as CSV
  • Noeffinway99 on Use PowerShell to Save Excel Worksheet as CSV
  • Unknown on Use PowerShell to Save Excel Worksheet as CSV
  • Unknown on History of Internet Addressing
Theme of 96 THEME.