Top "Getdate" questions

Retrieving date in sql server, CURRENT_TIMESTAMP vs GetDate()

Using SQL Server - which is the fastest or best practice method to use for date retrieval? Is there a …

sql-server getdate

GETDATE -1 or 2

With this: CONVERT(varchar(10),DATEADD(month,1,GETDATE()),120) I get this 2013-08-19 which is perfect but I need it to …

sql sql-server tsql getdate

php getdate() vs date()

Theoretical question. Imagine the situation. I need to get today date and time (not now, but today - the start …

php date getdate

date.getDate() is not a function. (In 'date.getDate()', 'date.getDate()' is undefined) FullCalendar in Ionic 3

I'm coding on a Ionic 3 project where i use a FullCalendar plugin for display a calendar ui. I've a problem …

javascript cordova ionic-framework fullcalendar getdate

How to add Leading Zero with getMonth in Java (Android)

I'm using an int variable: month = dp.getMonth() + 1; currently getting an output of "2" and when I do the following: if (…

java android date getdate

Getting the date from a ResultSet for use with java.time classes

Is there anyway to get a java.time (new in Java 8) compatible time class out of a ResultSet? I am …

java-8 resultset getdate java-time

Convert getdate() to int

When I run the following query: select convert(int, getdate()) I get the result: ----------- 41238 (1 row(s) affected) Does anyone …

sql casting int getdate

How to extract date from a DateNow() in YYYYMMDD format in SQL Server

Got a specific requirement that we should extract only date and in YYYYMMDD format from GETDATE() in Sql-Server 2005. How can …

date sql-server-2005 getdate

GETDATE() function in SQL server

When running the SQL query: select GETDATE() I get the below output: 2017-10-26 12:48:41.273 It displays the date and the …

sql sql-server-2008 date-formatting getdate

How to replace getDate() from the type Date which is deprecated?

I have an existing program that I have to correct . It contains these lines : Date startDate = new Date(); int day = …

java date calendar getdate