Maybe.

This would give you the local time of the server where SQL is installed.

Do you want to store timezone etc too? If so, [SYSDATETIMEOFFSET][1]() may be better


  [1]: http://msdn.microsoft.com/en-us/library/bb677334.aspx

How can I get log4j to delete old rotating log files?  I know I can set up automated jobs (cron for UNIX and scheduled task for Windows), but I want it cross platform, and I want it in our application&#39;s log configuration as a part of our application, rather than in separate code outside in OS specific scripting languages.  Our application is not written in OS scripting languages, and I don&#39;t want to do this part of it in them.

How can I get log4j to delete old rotating log files?

When I open a MySQL connection in PHP with just PHP&#39;s built-in MySQL functions, I do the following:

    $link = mysql_connect($servername, $username, $password);
    mysql_select_db($dbname);
    //queries etcetera
    mysql_close($link);

When I open a connection with PDO, it looks like this:

    $link = new PDO(&quot;mysql:dbname=$dbname;host=$servername&quot;,$username,$password);
    //prepare statements, perform queries

Do I have to explicitly close the connection like I do with `mysql_connect()` and `mysql_close()`?  If not, how does PHP know when I&#39;m done with my connection?

TIA.

Do SQL connections opened with PDO in PHP have to be closed

I&#39;m executing a INSERT to a sql 2008 db. How do I specify in T-SQL to insert NOW in a DATETIMEOFFSET column? GETDATE()?

DateTimeOffset.Now in T-SQL

<p>I'm executing a INSERT to a sql 2008 db. How do I specify in T-SQL to insert NOW in a DATETIMEOFFSET column? GETDATE()?</p>


I need to change the primary key of a table to an identity column, and there&#39;s already a number of rows in table. 

I&#39;ve got a script to clean up the IDs to ensure they&#39;re sequential starting at 1, works fine on my test database. 

What&#39;s the SQL command to alter the column to have an identity property?

Adding an identity to an existing column

I am creating a status board module for my project team. The status board allows the user to to set their status as in or out and they can also provide a note. I was planning on storing all the information in a single table ... and example of the data follows:

    Date               User		    Status    Notes
    -------------------------------------------------------
    1/8/2009 12:00pm   B.Sisko      In        Out to lunch    
    1/8/2009 8:00am    B.Sisko      In  
    1/7/2009 5:00pm    B.Sisko      In    
    1/7/2009 8:00am    B.Sisko      In    
    1/7/2009 8:00am    K.Janeway    In   
    1/5/2009 8:00am    K.Janeway    In    
    1/1/2009 8:00am    J.Picard     Out	      Vacation	


I would like to query the data and return the most recent status for each user, in this case, my query would return the following results:

    Date               User		    Status    Notes
    -------------------------------------------------------  
    1/8/2009 12:00pm   B.Sisko      In        Out to lunch    
    1/7/2009 8:00am    K.Janeway    In   
    1/1/2009 8:00am    J.Picard     Out	      Vacation	

I am try to figure out the TRANSACT-SQL to make this happen? Any help would be appreciated.

Create a SQL query to retrieve most recent records

What is the (default) charset for:

- MySQL database

- MySQL table

- MySQL column



How do I see what character set a MySQL database / table / column is?

I need to get the last day of the month given as a date in SQL. If I have the first day of the month, I can do something like this:

    DATEADD(DAY, DATEADD(MONTH,&#39;2009-05-01&#39;,1), -1)

But does anyone know how to generalize it so I can find the last day of the month for any given date?

Get the last day of the month in SQL

I am interested in learning how a database engine works (i.e. the internals of it).  I know most of the basic data structures taught in CS (trees, hash tables, lists, etc.) as well as a pretty good understanding of compiler theory (and have implemented a very simple interpreter) but I don&#39;t understand how to go about writing a database engine.  I have searched for tutorials on the subject and I couldn&#39;t find any, so I am hoping someone else can point me in the right direction.  Basically, I would like information on the following:

 - How the data is stored internally (i.e. how tables are represented, etc.)
 - How the engine finds data that it needs (e.g. run a SELECT query)
 - How data is inserted in a way that is fast and efficient

And any other topics that may be relevant to this. It doesn&#39;t have to be an on-disk database - even an in-memory database is fine (if it is easier) because I just want to learn the principals behind it.

Many thanks for your help.

How to write a simple database engine

I want to query the name of all columns of a table. I found how to do this in:

- [Oracle](https://stackoverflow.com/q/452464/419956)
- [MySQL](https://stackoverflow.com/q/193780/419956)
- [PostgreSQL](https://dba.stackexchange.com/q/22362/5089)

But I also need to know: **how can this be done in *Microsoft SQL Server* (2008 in my case)?**



How can I get column names from a table in SQL Server?

What are the differences between `numeric`, `float` and `decimal` datatypes and which should be used in which situations?

For any kind of financial transaction (e.g. for salary field), which one is preferred and why?


Difference between numeric, float and decimal in SQL Server

At least on my local instance, when I create tables, they are all prefixed with &quot;dbo.&quot;. Why is that?

Why do table names in SQL Server start with &quot;dbo&quot;?

I&#39;m using the following code:

    SELECT * FROM table
    WHERE Col IN (123,123,222,....)

However, if I put more than ~3000 numbers in the `IN` clause, SQL throws an error.

Does anyone know if there&#39;s a size limit or anything similar?!!

Limit on the WHERE col IN (...) condition

I want to make sure I&#39;m not inserting a duplicate row into my table (e.g. only primary key different).  All my fields allow NULLS as I&#39;ve decided null to mean &quot;all values&quot;.  Because of nulls, the following statement in my stored procedure can&#39;t work:

    IF EXISTS(SELECT * FROM MY_TABLE WHERE 
		MY_FIELD1 = @IN_MY_FIELD1  AND
		MY_FIELD2 = @IN_MY_FIELD2  AND
		MY_FIELD3 = @IN_MY_FIELD3  AND 
		MY_FIELD4 = @IN_MY_FIELD4  AND
		MY_FIELD5 = @IN_MY_FIELD5  AND
		MY_FIELD6 = @IN_MY_FIELD6)
		BEGIN
			goto on_duplicate
		END

since NULL = NULL is not true.

How can I check for the duplicates without having an IF IS NULL statement for every column?  

How to compare values which may both be null in T-SQL

I have a Table like this one:

    |UserId   |  ContactID |  ContactName 
    ---------------------------------------
    | 12456   |  Ax759     |  Joe Smith
    | 12456   |  Ax760     |  Mary Smith
    | 12458   |  Ax739     |  Carl Lewis
    | 12460   |  Ax759     |  Chuck Norris
    | 12460   |  Bx759     |  Bruce Lee

I need to add a constraint to this table so that no user can have duplicate contact id&#39;s.  The users are importing data from various external systems so ContactId will not be unique across the board but will be unique on a per user basis.

I know how to create Unique and Non-Null contraints based on single columns but how can I create a unique contraints across 2 columns?


How can I create a SQL unique constraint based on 2 columns?

I imported a bunch of tables from an old sql server (2000) to my 2008 database.  All the imported tables are prefixed with my username, for example: `jonathan.MovieData`.  In the table `properties` it lists `jonathan` as the db schema.  When I write stored procedures I now have to include `jonathan.` in front of all the table names which is confusing.

How do I change all my tables to be dbo instead of jonathan?

Current result: `jonathan.MovieData`

Desired result: `dbo.MovieData`

How do I change db schema to dbo

I want to move a table into a specific Schema using T-SQL? I am using SQL Server 2008.

How do I move a table into a schema in T-SQL

Is there a way I can get a scripting of all tables, procs, and other objects from a database?  I know there&#39;s an option to script the database but it only gave me some sort of top level script, certainly not a script to create all tables, procs, udfs, .etc.

Script entire database SQL-Server

It amazes me that JavaScript&#39;s Date object does not implement an add function of any kind.

I simply want a function that can do this:

    var now = Date.now();
    var fourHoursLater = now.addHours(4);

    function Date.prototype.addHours(h) {

       // How do I implement this?

    }

I would simply like some pointers in a direction.

  - Do I need to do string parsing?

  - Can I use setTime?

  - How about milliseconds?

Like this:

    new Date(milliseconds + 4*3600*1000 /* 4 hours in ms */)?

This seems really hackish though - and does it even work?




How to add hours to a Date object?

I want to compare two dates with time, I want all the results `from tbl where date1 &gt; date2`

    Select * From temp where mydate &gt; &#39;2009-06-29 04:00:44&#39;;

but it is just comparing dates not time. it is giving me all the result set of today&#39;s date

    &#39;2009-06-29 11:08:57&#39;
    &#39;2009-06-29 11:14:35&#39;
    &#39;2009-06-29 11:12:38&#39;
    &#39;2009-06-29 11:37:48&#39;
    &#39;2009-06-29 11:52:17&#39;
    &#39;2009-06-29 12:12:50&#39;
    &#39;2009-06-29 12:13:38&#39;
    &#39;2009-06-29 12:19:24&#39;
    &#39;2009-06-29 12:27:25&#39;
    &#39;2009-06-29 12:28:49&#39;
    &#39;2009-06-29 12:35:54&#39;
    &#39;2009-06-29 12:36:54&#39;
    &#39;2009-06-29 12:49:57&#39;
    &#39;2009-06-29 12:58:04&#39;
    &#39;2009-06-29 04:13:20&#39;
    &#39;2009-06-29 04:56:19&#39;
    &#39;2009-06-29 05:00:23&#39;
    &#39;2009-06-29 05:04:26&#39;
    &#39;2009-06-29 05:08:17&#39;
    &#39;2009-06-29 05:26:57&#39;
    &#39;2009-06-29 05:29:06&#39;
    &#39;2009-06-29 05:32:11&#39;
    &#39;2009-06-29 05:52:07&#39;

Thanks in advance!

Mysql Compare two datetime fields

I have the following code to do this, but how can I do it better? Right now I think it&#39;s better than nested loops, but it starts to get Perl-one-linerish when you have a generator in a list comprehension. 

&lt;!-- language: lang-py --&gt;

    day_count = (end_date - start_date).days + 1
    for single_date in [d for d in (start_date + timedelta(n) for n in range(day_count)) if d &lt;= end_date]:
        print strftime(&quot;%Y-%m-%d&quot;, single_date.timetuple())


## Notes

* I&#39;m not actually using this to print. That&#39;s just for demo purposes. 
* The `start_date` and `end_date` variables are `datetime.date` objects because I don&#39;t need the timestamps. (They&#39;re going to be used to generate a report).

## Sample Output 
For a start date of `2009-05-30` and an end date of `2009-06-09`:

&lt;!-- language: lang-py --&gt;

    2009-05-30
    2009-05-31
    2009-06-01
    2009-06-02
    2009-06-03
    2009-06-04
    2009-06-05
    2009-06-06
    2009-06-07
    2009-06-08
    2009-06-09

Iterating through a range of dates in Python

I&#39;m having some trouble with the output of a DateTime value. My computer&#39;s current culture is set to de-AT (Austria).

The following code

    string s1 = DateTime.Now.ToString(&quot;d&quot;);
    string s2 = string.Format(&quot;{0:d}&quot;, DateTime.Now);

results in s1 and s2 both having the correct value of &quot;30.06.2009&quot;.

But when using the same format in XAML

        &lt;TextBlock Text=&quot;{Binding Source={x:Static sys:DateTime.Now}, StringFormat=d}&quot;/&gt;

the output is `&quot;6/30/2009&quot;. It seems the XAML StringFormat ignores the current culture settings. This happens on both Vista and XP.

I don&#39;t want to specify a custom format, because the output should be formatted in the user&#39;s preferred culture setting.

Anybody with the same problem? Is this a bug in WPF?

WPF XAML StringFormat DateTime: Output in wrong culture?

I am trying to figure out whether or not the current date falls within a date range using NSDate.

For example, you can get the current date/time using NSDate:

    NSDate rightNow = [NSDate date];

I would then like to use that date to check if it is in the range of **9AM - 5PM**.

Content Type	Original Author	Original Content on Stackoverflow
Question	Robert	View Question on Stackoverflow
Solution 1 - Sql	gbn	View Answer on Stackoverflow

DateTimeOffset.Now in T-SQL

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Do SQL connections opened with PDO in PHP have to be closed

How can I get log4j to delete old rotating log files?

Attributions