Top "Sqldatetime" questions

The SQLDateTime tag is for questions related to how database SQL queries handle date and time information.

Converting java date to Sql timestamp

I am trying to insert java.util.Date after converting it to java.sql.Timestamp and I am using the …

java sql datetime sqldatetime
.NET DateTime to SqlDateTime Conversion

While converting .NET DateTime (when is default(DateTime)) to SqlDateTime should I always check if the .NET date is between …

c# .net datetime sqldatetime
Filter data based on date in sql

Im trying to execute the following SQL query and filter out the data based on the date. I need to …

sql sql-server sql-server-2008 sql-date-functions sqldatetime
How to convert LocalDate to SQL Date Java?

How do I convert a LocalDate to a java.sql.Date? Attempt: Record r = new Record(); LocalDate date = new Date(1967, 06, 22); …

java java-8 converter java-time sqldatetime
how to convert date into month number?

I have a column Month in my table. The month name and date are stored in this month column like …

sql oracle sqldatetime
Check if value is date and convert it

I receive data in a certain format. Dates are numeric(8,0). For example 20120101 = YYYYMMDD There exists rows with values like (0,1,2,3,6) in …

sql sql-server sqldatetime
Servlet get date and time

I'm using the following code to get the date and time public class offer extends HttpServlet { @Override protected void doGet(…

java datetime servlets time sqldatetime
SQL Server - Round TIME values to the next minute

I've found many posts about rounding "down" time values (e.g. https://stackoverflow.com/a/6667041/468823), but I have another problem: …

sql sql-server-2008 tsql rounding sqldatetime
Converting a date a string to java.sql.Date format

I'm having an issue while trying to insert a date into an SQL server using Java: //final String input = "20120823151034"; final …

java sql date sqldatetime
C# string to SqlDateTime: how to set format for recognition?

I need to use SqlDateTime.Parse(val) where val is a string such as " 23.3.1992 00:00:00 ". The string is in European format, …

c# asp.net datetime locale sqldatetime