Top "Getdate" questions

How to print GETDATE() in SQL Server with milliseconds in time?

I want to print GETDATE() in SQL Server 2008, I need the time with milliseconds (this is for debugging purpose - …

sql sql-server sql-server-2008 datetime getdate

Rounding SQL DateTime to midnight

I am having a small problem with my SQL query. I'm using the GETDATE function, however, let's say I execute …

sql sql-server sql-server-2005 getdate

SELECT CONVERT(VARCHAR(10), GETDATE(), 110) what is the meaning of 110 here?

When we convert or cast date in sql, see below sql code SELECT CONVERT(VARCHAR(10), GETDATE(), 110) AS [MM-DD-YYYY] it works …

sql date casting getdate

JDBC ResultSet: I need a getDateTime, but there is only getDate and getTimeStamp

I would like to get the DATETIME column from an Oracle DB Table with JDBC. Here is my code: int …

java sql oracle resultset getdate

SSIS expression: convert date to string

I'm new to SSIS and I'm trying to convert a GetDate() to string "DD-MM-YYYY". This is the expression I've built …

ssis expression getdate

JavaScript's getDate returns wrong date

The following script returns 20 instead of 21! var d = new Date("2010/03/21"); document.write(d.getDate()); What am I doing wrong? Is …

javascript getdate

Incorrect syntax near ')' calling stored procedure with GETDATE

Maybe I am having a moment of 'afternoon', but can anyone explain why I get Msg 102, Level 15, State 1, Line 2 Incorrect …

sql-server tsql getdate

how to format getdate into YYYYMMDDHHmmSS

In SQL Server how do I format getdate() output into YYYYMMDDHHmmSS where HH is 24 hour format? I've got the YYYYMMDD …

sql-server-2005 getdate

SQL Query to restrict return dates to current month

I am trying to restrict my returned data to only those points that have start and end dates in the …

sql-server-2008 datetime filter getdate

How do I add 1 hour to datetime SQL column data?

I used this part of a query to create a table column for the date and time a row is …

sql sql-server datetime getdate hour