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