63
votes
16
answers
2.6K
views
How can I do an UPDATE statement with JOIN in SQL Server?
I need to update this table in SQL Server with data from its 'parent' table, see below: Table: sale
60
votes
30
answers
2.9K
views
How to return only the Date from a SQL Server DateTime datatype
SELECT GETDATE() Returns: 2008-09-22 15:24:13.790 I want that date part without the time part: 2008-09-22 0
53
votes
10
answers
1.5K
views
Why is subtracting these two times (in 1927) giving a strange result?
If I run the following program, which parses two date strings referencing times 1 second apart and compares th
58
votes
30
answers
1.3K
views
63
votes
30
answers
1K
views
How do I use PHP to get the current year?
I want to put a copyright notice in the footer of a web site, but I think it's incredibly tacky for the y
