Top "Getdate" questions

getdate is a T-SQL function available to retrieve the current system date and time.

CASE statement with GETDATE()

Wondering if you can help a little with the syntax here. Trying to set a variable as a month value …

sql sql-server-2008 case getdate
strptime in c with timezone offsets

I'm having trouble finding a way to parse the timezone out of strings like the following: "Thu, 1 Sep 2011 09:06:03 -0400 (EDT)" …

c timezone getdate strptime timezone-offset
Between older than 30 days and less than 90days

I need to return records where there is a date older than 30days but less than 90days. so If someone …

sql-server-2008 datediff getdate
How can I Add Time to a Date in jQuery

How do I add 23 hrs 59 min. 59 secs to end_date? var end_date = jQuery('#end_date_datepicker').datepicker('getDate'); //…

jquery jquery-ui date jquery-ui-datepicker getdate
Changing the output of Getdate

Is it possible to deceive SQL Server to return a different date on GetDate() without actually changing the machine date? …

sql-server getdate
Powershell HowTo get last day of 2 month ago

I've a script scheduled every 4th and 14th day of month. when script starts on 4th, I need to get …

date powershell getdate
GETDATE in DEFAULT constraint on some tables in SQL Server 2012

As u expect I have got problem with GETDATE in DEFAULT constraint on some tables in SQL Server 2012. I have …

sql sql-server constraints getdate
Copying a file and adding the date to its name in PowerShell

Why doesn't this work?: Copy-Item "C:\Logs\VPNLog.txt" "C:\Backup\VPNLog$(Get-Date -UFormat %d-%m-%Y-%R).txt" Error …

powershell getdate