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
2 answers

Month closest actual month

i have this table: Players: ID (int) Birthday (datetime) I need choose 3 first players, which have birthday in the actual month... I have this but the result is nothing.. Have you any idea? SELECT * FROM Players WHERE Birthday < DATEADD(month, -2,…
Kate
  • 372
  • 2
  • 11
  • 24
0
votes
0 answers

TSQL Rolling Date for Every Thursday at 4:00pm

I would like to create a Select Statement which uses a Rolling Date on Every Thursday at 4:00pm. We are working on a project where we are using informz as our Web Application to send email blasts to our New Members. I would like to create a Select…
scottgobucks
  • 21
  • 2
0
votes
1 answer

GetDate from datepicker of the other months

I need your help with a problem in Datapicker. I am starting works with JQuery, and I need to do an agenda, when the user click in some day of the calendar, I need get this date to capture all schedule of the day selected. Problem: When I click in…
user2463664
  • 1
0
votes
1 answer

How to change date value to Unicode with Javascript?

How can I convert a month and year value into Unicode using Javascript? For instance, "6, 2013" would become "\u1046, \u1042\u1040\u1041\u1043" (Myanmar text). Patrick pointed me to Codepen where I got this: