Stack Overflow
Stack Overflow

Questions tagged [getdate]

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

getdate() is a function that returns the current system date and time in a datetime format in RDBMSs that use T-SQL. It is available for use in MS SQL Server, SAP/Sybase Adaptive Server Anywhere, SAP/Sybase SQL Anywhere and SAP/Sybase IQ.

412 questions
0
votes
1 answer

$("datepicker").getdate() not working into new tabs

Possible Duplicate: datepicker not working into new tabs When I click button "add tab". Jquery will create new tab and new datepicker for me. But I can't get date on new datepicker. It is null. How to selector new datepicker into new tabs ?? My…
user1761176
  • 103
  • 3
  • 4
  • 16
0
votes
3 answers

Why Datediff between GETDATE() and SYSDATETIME() in milliseconds is always different?

I am trying to get Datediff between GETDATE() and SYSDATETIME() in milliseconds. SELECT DATEDIFF(ms, GETDATE() , SYSDATETIME()); The result I am getting is 0 or 1 or 2 or 3. What is the reason for this difference? See this fiddle.
Himanshu
  • 31,810
  • 31
  • 111
  • 133
0
votes
2 answers

Run a query based on today's date

I am making a program that auto-runs using windows scheduler. What I'd like to do is set the program to run on the 1st and the 16th of every month. If the program run's on the 1st. I'd like to have the query run for last month... For example if…
Shmewnix
  • 1,553
  • 10
  • 32
  • 66
0
votes
2 answers

How do I execute scripts based on what month/day it is?

Okay, I feel like I should be able to do this, but I have searched to no avail. I need to show one of two different data sets depending on what day of the year it is. Specifically, if today is October 31 (or earlier,) I want to pull all entries…
gmaness
  • 154
  • 1
  • 12
-1
votes
1 answer

Filtering an INNER JOIN to get only values that have ending date 30 days from now

I've got this kinda big query that is working as expected, now I want to make another query that returns only rows which have an ending date between today and 30 days from now. What I've tried: SELECT clientes.nome, docs.apolice,…
Johnny Gregório
  • 1
  • 1
-1
votes
1 answer

Windows Command Line Powershell error: Missing closing ')' in expression

I'm having trouble formatting this to run as a single command line. powershell ("$today = [system.datetime](Get-Date); $startTime = $today.AddHours(-4); Get-WinEvent -FilterHashtable @{LogName='Application'; ProviderName='Application…
Michele
  • 3,617
  • 12
  • 47
  • 81
-1
votes
1 answer

sum number each day javascript / jquery

every day add the value in the div with + 1 a type of counter ... var i = 1; $(".teste").each(function () { i = parseFloat(i) + parseFloat($(this).data("teste")); }); $(".teste").html(i);
visionswebart diego
  • 1
  • 1
-1
votes
1 answer

PHP getdate echo if yday equals

Using PHP getdate(); I get the following array output: Array ( [seconds] => 54 [minutes] => 26 [hours] => 19 [mday] => 10 [wday] => 5 [mon] => 12 [year] => 2021 [yday] => 343 [weekday] => Friday …
Simon Hayter
  • 3,131
  • 27
  • 53
-1
votes
1 answer

cast MS Access DATE() to Getdate()

I have an ODBC linked table in MS Access to SQL Server. In a query in MS Access, I have the following expression on a field: DATE() - [DATE] (a field). I need to change MS Access function DATE(), i.e. current date to SQL Server GETDATE(). How can…
Robleh100
  • 1
-1
votes
1 answer

Create a dynamic date range in SQL

I'm a new learner in SQL and trying to create a dynamic date range based on the current month. For instance, if the current month is June, then the start date should be May 1st and the end date should be May 31st, etc. Here is the code: For start…
Cyan
  • 319
  • 2
  • 8
-1
votes
2 answers

SQL error: conversion failed when converting the varchar value '2020-11-26' to data type bit

I have this trigger - can you fix error please in this code? INSERT INTO trSMSPoolHeader (SMSGatewayServiceCode, IsSent, SendDate, CreatedDate, LastUpdatedDate, CompanyCode, StoreTypeCode, MessageResponseID, …
a.b
  • 15
  • 1
  • 7
-1
votes
1 answer

How to check if a user passed date is Wednesday using PowerShell?

I have an use case where user passes a date from the past. But I need to check if it's a Wednesday. If not, I want to be able to set it to next Wednesday 5 AM. Can somebody please tell me what would be best approach to go about this using…
user193020
  • 3
  • 1
-1
votes
2 answers

Getdate() function does not work in SQL Server 2014 Express

I am a newbie to programming. I downloaded the free version of SQL Server 2014, the Express edition. Somehow the Getdate() function is not working. It says Incorrect syntax near '('. If I just say GETDATE. It says Could not find stored…
Sharath Chandra
  • 1
  • 1
  • 2
-1
votes
1 answer

Using GETDATE() to pull from a table

My apologies in advance for the basic (and probably silly) question. I'm doing a SELECT query where I'm joining several tables. I have a table that contains a numeric value associated with certain days. What I would like to have in my output is…
The Kurgan
  • 3
  • 2
-1
votes
1 answer

How to write a SQL getdate function to conditionally use 1 of a few possible end dates

I work in Mortgage. Once an Underwriter receives a file (marked as "submitted to Underwriting"), that Underwriter can either approve, approve with conditions, or suspend that file. I am trying to find the number of days that it takes the Underwriter…
Josh Briggs
  • 27
  • 5
1 2 3
…
27 28