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
-2
votes
1 answer

Get dates of next 8 Saturdays (javascript)

I was able to get date of closest Saturday - CodePen Need help with finding dates of the next seven saturdays. Thank you function myFunction(x){ var now = new Date(); now.setDate(now.getDate() + (x+(7-now.getDay())) % 7); …
Vitaliy Hayda
  • 113
  • 2
  • 11
-2
votes
2 answers

php print current day plus to days

I think the question says it all. I am not sure how to get the currentdate + 2 days. here was my attempt //insert invoice table $currentdate = getdate(); $duedate = getdate() + 2000; $makeinvoice =…
CudoX
  • 985
  • 2
  • 19
  • 31
-3
votes
0 answers

Powershell date comparison with value from array does not work

I am pinging an array of IP addresses. If there is no connection, an email should be sent after one hour for each connection. For this I write a new time value in the array $Emailsssent. Unfortunately, the if query does not work with the current…
Michael
  • 43
  • 1
  • 1
  • 6
-3
votes
2 answers

java datechooser how to get date

DateFormat dateformatYYYYMMDD = new SimpleDateFormat("yyyyMMdd"); String nowYYYYMMDD = new String( dateformatYYYYMMDD.format( dateChooser.getDate()) ); textField_1.setText(nowYYYYMMDD); i tried this way but i cant get date from…
Edgar Buchvalov
  • 257
  • 2
  • 12
  • 22
-3
votes
1 answer

d.setDate(d.getDate()+7) returns a bunch of numbers

When i run the code bellow, which parses the current date + 7 days, returns huge number on the date variable; let d = new Date(); let n = d.setDate(d.getDate()+7); let m = d.getMonth()+1; let o = d.getFullYear(); let dateOp = n + "/" + m + "/" +…
M. M.
  • 11
  • 3
-3
votes
1 answer

MSSQL Edit date (YEAR, MONTH) in one command

I need manipulate with time in one command. I have this date "15.02.2013" and now i need this time change on this "15.01.2012". Date is dynamic stats for me. i need change time with this functions (GATEDATE, YEAR, MONTH) or…
user2967933
  • 9
  • 2
-5
votes
1 answer

Display next future date in array

I'm looking for a simple solution that outputs the closest future date from an array of dates I select. eg. Array = Mon 2nd December 2019, Monday 16th December 2019, Thu 2nd January 2020, Wed 15th January, etc If current date is eg. '25th December,'…
Dan Segelov
  • 3
1 2 3
…
27
28