Michael Stassen wrote:
So, take a look at yarn_date.txt and let us know.
Yes, you're right . . . there was an extra tab stop. When I deleted the
extra tab, the date field were retained successfully. Thanks!
--
Lola - mailto:[EMAIL PROTECTED]
http://www.lolajl.net | Blog at http://www.l
Lola J. Lee Beno wrote:
Here's an example of one of the tables where the date was retained
successfully, with the string to the right of the decimal point being
trimmed:
1Cobweb2005-01-13 15:21:50.654149
2Lace Weight2005-01-13 15:21:50.654149
3Sock2005-01-13 15:21:50.6
Michael Stassen wrote:
Just a quick reply for now . . .
Ummm, if you delete the numbers to the *left* of the decimal point,
"2005-01-15 10:15:42.41837" will turn into ".41837", which is still not
a valid datetime. You need to delete the numbers to the *right* of the
decimal point (which I ex
Lola J. Lee Beno wrote:
I have a bunch of data where one of the columns is a date field. Here's
a sample of the data that I have:
141415010001 02005-01-15 10:15:42.41837
281512010002 02005-01-15 10:22:37.756594
36
Thanx, that's exactly it. I feel a bit embarassed as this came up on
the list about 2-3 weeks ago, and I found the answer as I was waiting
for the replies.
-Sheeri
On 1/20/06, gerald_clark <[EMAIL PROTECTED]> wrote:
> sheeri kritzer wrote:
>
> >Hi folks,
> >
> >I'm attempting to optimize a quer
sheeri kritzer wrote:
Hi folks,
I'm attempting to optimize a query -- it's quite a simple one, actually.
SELECT uid from Bill_Sales WHERE startDate > '[some date]';
mysql> show create table Bill_Sales\G
*** 1. row ***
Table: Bill_Sales
Cre
Realized I should probably show the Bill_Sales table. . .
ls -lh Bill_Sales.*
-rw-rw 1 mysql mysql 104M Jan 20 15:11 Bill_Sales.MYD
-rw-rw 1 mysql mysql 97M Jan 20 15:11 Bill_Sales.MYI
-rw-rw 1 mysql mysql 9.2K Jan 3 13:43 Bill_Sales.frm
mysql> show table status like "Bill_Sales"
Eduardo
Use the format '-mm-dd' instead
By the way, there is an excellent manual on http://www.mysql.com including
all the field types and formats
Freddie
-Original Message-
From: Eduardo Melo [mailto:[EMAIL PROTECTED]
Sent: Sonntag, 26. Oktober 2003 16:15
To: [EMAIL PROTECTED]
Hello.
On Sun 2002-12-08 at 16:03:22 -0500, [EMAIL PROTECTED] wrote:
>
> I am trying to store a date in the following format '08/12/2002' pr
> '08/12/2002' or any other format if I have to ...on SQLServer 7.
This is the mysql list. What has SQLServer 7 to do with MySQL?
> Basically I want to us
At 1:32 -0700 9/18/02, neal wrote:
>Is there a wat to have mySQL auto fill in the current date into my
>dateCreated field?
>
>In SQLServer I would simply specify the getDate() method as a default value.
>I presume I would use the analogous MySQL function curDate() but it does not
>appear to work f
neal,
Wednesday, September 18, 2002, 11:32:39 AM, you wrote:
n> Is there a wat to have mySQL auto fill in the current date into my
n> dateCreated field?
n> In SQLServer I would simply specify the getDate() method as a default value.
n> I presume I would use the analogous MySQL function curDate()
Check TIMESTAMP type in the documentation.
Best regards,
Mikhail.
- Original Message -
From: "neal" <[EMAIL PROTECTED]>
To: "mySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, September 18, 2002 10:32 AM
Subject: date field - default value = current date
> Is there a wat to have mySQL auto fi
From: "Anvar Hussain K.M." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 11 January 2002 04:05
Subject: Re: Date Field + Time Field = Datetime Field?
> Hi Alex,
>
> I don't think your problem will solved by making the time columns to full
> datetime c
Hi Alex,
I don't think your problem will solved by making the time columns to full
datetime columns as there is no
functions to subtract two datetime values directly.
But you can can keep the time columns and go on like this:
convert the time into seconds using time_to_sec function.
subtract f
On 23-Jul-2001 Mike Mike wrote:
> Hi Folks,
> I'm trying to create a counter for my website. I'm
> trying to pull the last 7 days worth of data out of
> mysql. My sql statement is as follows.
>
> SELECT TheDate, Count(TheDate) AS CountOfdate
> FROM Counter
> WHERE (((TheDate)=Now()-7))
> GROUP
Of course, 0 records are ok. Here is an example of mine :
mysql> select now(), now()-7;
+-++
| now() | now()-7|
+-++
| 2001-07-23 21:45:53 | 20010723214546 |
+-++
1 r
Use the "timestamp" datatype instead of date.
At 05:19 PM 1/13/2001 -0500, you wrote:
>Hello,
>
>Is there a way to have a field of type DATE get the current date as its
>default?
>
>Something like ...
>
>mydatefield DATE DEFAULT curdate()
>
>...which does not work. But that's the idea.
---
>Hello,
>
>Is there a way to have a field of type DATE get the current date as its
>default?
No. Default values in MySQL must be constants.
>
>Something like ...
>
>mydatefield DATE DEFAULT curdate()
>
>...which does not work. But that's the idea.
--
Paul DuBois, [EMAIL PROTECTED]
---
18 matches
Mail list logo
