Lab Sql

I am looking to identify return visitors to a website within a 7 day window. A data sample and atte… Read more Postgresql: Identifying Return Visitors Based On Date - Joins Or Window Functions?

I am trying to import a column of dates from a spreadsheet in Excel 2003 into SQL Server 2005 using… Read more Date Format Problem Using Ssis For Excel Into Sql Server

I'm having an issue where a C# DateTime string is failing to convert to a SQL DateTime because … Read more Convert.tostring(datetime) Yielding Uk Format Instead Of Us

I'm using SQL server 2008. I have 2 Tables: Table 1 and Table 2. Table 1 has 1 column called: O… Read more Sql Convert Nvarchar(255) To Datetime Problem

I am working with SQLAlchemy, and I'm not yet sure which database I'll use under it, so I w… Read more Can Sqlalchemy Datetime Objects Only Be Naive?

I have attendance record table like this +----------------+---------+-----------------------+ | NI… Read more Datetime String To Date, In Time And Out Time

Need some help with this: Create a table called TEMP_STUDENT with the following columns and cons… Read more Check Constraint To Restrict The Registration Date To Dates After August 26, 2005

How do you perform a LIKE statement on a column of DateTime datatype in SQL Server? If I run the fo… Read more Sql Like Statement On A Datetime Type

If $Time is null, then in the query it is substituted by ''. As a result the query is incor… Read more Null Value Is Substituted By ''

I have two tables: MainTable and MyTable. MyTable has unique ControlNo and ID. I need to add very f… Read more How To Loop Through Table Using While Loop And Create Another Table With Values Needed

I'm executing a INSERT to a sql 2008 db. How do I specify in T-SQL to insert NOW in a DATETIMEO… Read more Datetimeoffset.now In T-sql

I have a few columns in an SQL server 2008 R2 database that i need to convert from local time (the … Read more Sql Server: Convert Between Utc And Local Time Precisely

Here is my code: UVCUpdate update = new UVCUpdate(); update.CurrentDate = DateTime.Now; _context.UV… Read more Entity Framework Not Claiming Datetime.now Is Null

I have hibernate configured as auto-update. I have a mssql-server 2012. Hibernate creates my java.u… Read more Use Datetime Instead Of Datetime2 Sqlserver Hibernate

I am using SQL Server 2008. First I gave SqlDbType.Time for System.TimeSpan to the parameter type f… Read more Failed To Convert Parameter Value From A Timespan To A Datetime

I wonder whether sqlite3 supports interval function. The following statement is accepted by Postgre… Read more Sqlite3 Date And Interval Functions

I pull data from a websource and it returns time in the format 'YYYY-MM-DDTHH:MM:SS.SSSZ'. … Read more Datetime String To Number Of Milliseconds

I was wondering what is the best way to parse a DateTime object to your SQL server. Where you are … Read more Best Way To Parse Datetime To Sql Server

Here is the problem I am facing: I got a large table containing rows, I want to group them by near … Read more Group Data Rows By Near Time

I am reading data from an access db and storing it in a temporary sql table then truncate the main … Read more Date Must Be Between 1/1/1753 12:00:00 Am And 12/31/9999 11:59:59 Pm Overflow Error Sqlbulkcopy