At 20:23 -0400 4/19/04, Stormblade wrote:
On Mon, 19 Apr 2004 17:36:50 -0500, Paul DuBois wrote:
Sorry if I wasn't clear. One of the things you wanted to do was have
a column that is set automatically to record-creation time when the
record is created, but not updated automatically when the re
On Mon, 19 Apr 2004 17:36:50 -0500, Paul DuBois wrote:
> Sorry if I wasn't clear. One of the things you wanted to do was have
> a column that is set automatically to record-creation time when the
> record is created, but not updated automatically when the record is
> updated later. You will be
At 17:55 -0400 4/19/04, Stormblade wrote:
On Sun, 18 Apr 2004 14:18:40 -0500, Paul DuBois wrote:
At 13:30 -0400 4/18/04, Stormblade wrote:
On Sun, 18 Apr 2004 12:17:00 -0400, Michael Stassen wrote:
Stormblade wrote:
Hey all,
I'm currently converting a SQLServer 2000 database over to
MyS
On Sun, 18 Apr 2004 14:18:40 -0500, Paul DuBois wrote:
> At 13:30 -0400 4/18/04, Stormblade wrote:
>>On Sun, 18 Apr 2004 12:17:00 -0400, Michael Stassen wrote:
>>
>>> Stormblade wrote:
>>>
Hey all,
I'm currently converting a SQLServer 2000 database over to MySQL. I have a
w
At 13:30 -0400 4/18/04, Stormblade wrote:
On Sun, 18 Apr 2004 12:17:00 -0400, Michael Stassen wrote:
Stormblade wrote:
Hey all,
I'm currently converting a SQLServer 2000 database over to MySQL. I have a
web application that currently uses SQLServer but will be using MySQL soon
as I can get
At 13:30 -0400 4/18/04, Stormblade wrote:
On Sun, 18 Apr 2004 12:17:00 -0400, Michael Stassen wrote:
Stormblade wrote:
Hey all,
I'm currently converting a SQLServer 2000 database over to MySQL. I have a
web application that currently uses SQLServer but will be using MySQL soon
as I can get
On Sun, 18 Apr 2004 14:42:51 -0400, Michael Stassen wrote:
> Stormblade wrote:
>
>> On Sun, 18 Apr 2004 12:17:00 -0400, Michael Stassen wrote:
> Functions are evaluated by the server. The client only sends queries and
> receives results. So, CURDATE() and NOW() are server time, not client tim
On Sun, 18 Apr 2004 13:54:22 -0400, Rhino wrote:
> Stormblade (and anyone watching this thread),
>
> Just watch yourself when deciding between DATETIME and TIMESTAMP; the two
> datatypes support very different ranges of values!
Thanks for the heads up!
>
> According to the manual, DATETIME can
Stormblade wrote:
On Sun, 18 Apr 2004 12:17:00 -0400, Michael Stassen wrote:
Stormblade wrote:
Hey all,
I'm currently converting a SQLServer 2000 database over to MySQL. I have a
web application that currently uses SQLServer but will be using MySQL soon
as I can get this done.
I was able to m
t what values you'll have to store before you make a
final choice of the datatype.
Rhino
- Original Message -
From: "Stormblade" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 18, 2004 1:30 PM
Subject: Re: Datetime Default Value
> On Sun
On Sun, 18 Apr 2004 12:17:00 -0400, Michael Stassen wrote:
> Stormblade wrote:
>
>> Hey all,
>>
>> I'm currently converting a SQLServer 2000 database over to MySQL. I have a
>> web application that currently uses SQLServer but will be using MySQL soon
>> as I can get this done.
>>
>> I was able
Stormblade wrote:
Hey all,
I'm currently converting a SQLServer 2000 database over to MySQL. I have a
web application that currently uses SQLServer but will be using MySQL soon
as I can get this done.
I was able to match data types but so far I have not found a way to let the
database handle sett
Changing the SQL works fine as long as:
a) You have access to the application source and/or the SQL source
b) There is only one application and it runs on the same machine as the
database.
If you change your SQL what happens if you have several applications all in
different timezones that use the
This is a great question! I also work on SQL Server (2k) databases as
well as Access and MySQL. I run into the same problem. So far, I've
just changed the SQL in my applications, but I also would like to know
if a default can be set.
Regards,
Adam
On Apr 18, 2004, at 12:01 AM, Stormblade wrote:
Hey all,
I'm currently converting a SQLServer 2000 database over to MySQL. I have a
web application that currently uses SQLServer but will be using MySQL soon
as I can get this done.
I was able to match data types but so far I have not found a way to let the
database handle setting the default va
15 matches
Mail list logo
