From DATE_FORMAT and back to origin date in mysql date column

SELECT DATE_FORMAT(dato, '%e/%c/%Y') AS dato FROM transportdokument WHERE dato = '2013-07-20' AND dato = '2013-07-24' GROUP BY dato DESC is working perfect in my PHP file. But I need to transfer the date back from my norwegian formatted date to the origin date format in WHERE dato =

RE: From DATE_FORMAT and back to origin date in mysql date column

...@gmail.com] Sent: Wednesday, July 24, 2013 7:02 AM To: MySQL Mailinglist Subject: From DATE_FORMAT and back to origin date in mysql date column SELECT DATE_FORMAT(dato, '%e/%c/%Y') AS dato FROM transportdokument WHERE dato = '2013-07-20' AND dato = '2013-07-24' GROUP BY dato DESC is working perfect

Re: Is there any determined date for mysql 6 release?

legolas schrieb: Hi Thank you for reading my post Is there any scheduled date mysql 6 release? don't know I heard that it is based on falcon and can perform better... based on in the wrong term, MyISAM will still be the default storage engine, it just adds Falcon as a new storage engine

Is there any determined date for mysql 6 release?

Hi Thank you for reading my post Is there any scheduled date mysql 6 release? I heard that it is based on falcon and can perform better... Thanks. -- View this message in context: http://www.nabble.com/Is-there-any-determined-date-for-mysql-6-release--tp14968233p14968233.html Sent from

How to emulate a DATE() in MySQL 4.0?

Hello mysql, I have a PHP script that I have written and it runs beautifully on current MySQL and PHP sites BUT, it barfs on MySQL 4.0 because I am using the DATE() to extract the Date from a timestamp. Does anyone remember how to do an equivalent function in 4.0? I have searched through hundreds

Re: How to emulate a DATE() in MySQL 4.0?

[EMAIL PROTECTED] wrote: Hello mysql, I have a PHP script that I have written and it runs beautifully on current MySQL and PHP sites BUT, it barfs on MySQL 4.0 because I am using the DATE() to extract the Date from a timestamp. Does anyone remember how to do an equivalent function in 4.0? I

ddmmyyyy-format date hangs MySQL - 5.0.22/InnoDB/WinXP-SP2

Hi, In my earlier post, I was making a mistake (though I didn't do so in the posted text!) - I was passing the dob (the date field) in the ddmm format. When I passed the date field in mmdd format, the stored procedure ran fine and the record got inserted. The problem is MySQL

Converting date in MySQL

Hi, I am taking user input via a calendar widget (guess it's js) Apparently, mysql does not like the format MM/DD/ Then again I tried it around , still no dice. It's intended to go into a Date column. Is there a way I can correct it right within my query ? Stuart -- MySQL General

Re: Converting date in MySQL

On Thursday 14 October 2004 02:45 pm, Stuart Felenstein wrote: Apparently, mysql does not like the format MM/DD/ Then again I tried it around , still no dice. It's intended to go into a Date column. http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html All, you every need to

Re: Converting date in MySQL

Thanks , I know the page and have the links bookmarked! Stuart --- Jeff Smelser [EMAIL PROTECTED] wrote: On Thursday 14 October 2004 02:45 pm, Stuart Felenstein wrote: Apparently, mysql does not like the format MM/DD/ Then again I tried it around , still no dice. It's intended

Re: Converting date in MySQL

On Thursday 14 October 2004 03:12 pm, Stuart Felenstein wrote: Thanks , I know the page and have the links bookmarked! So you got the answer from it right? Jeff pgpSsmcBOJscM.pgp Description: PGP signature

Re: Converting date in MySQL

No :),. cause it seems that those formats are for outbound, db -. I was looking for the other direction. Stuart --- Jeff Smelser [EMAIL PROTECTED] wrote: On Thursday 14 October 2004 03:12 pm, Stuart Felenstein wrote: Thanks , I know the page and have the links bookmarked! So you got the

Re: Converting date in MySQL

On Thursday 14 October 2004 03:35 pm, Stuart Felenstein wrote: No :),. cause it seems that those formats are for outbound, db -. I was looking for the other direction. Huh? It really doesnt matter does it? They work either way.. I use those functions all the time for inbound.. Jeff

Re: Converting date in MySQL

For values headed into a SQL statement, use whatever functions are available to you in the language (PHP, PERL, Python, Java, VB Script,...) you are using to accept the user's input in order to make the commands you send MySQL correct. You just need to convert the date into -MM-DD

Re: Converting date in MySQL

On Thursday 14 October 2004 03:46 pm, [EMAIL PROTECTED] wrote: For values headed into a SQL statement, use whatever functions are available to you in the language (PHP, PERL, Python, Java, VB Script,...) you are using to accept the user's input in order to make the commands you send MySQL

RE: Converting date in MySQL

From: Jeff Smelser [mailto:[EMAIL PROTECTED] On Thursday 14 October 2004 03:35 pm, Stuart Felenstein wrote: No :),. cause it seems that those formats are for outbound, db -. I was looking for the other direction. Huh? It really doesnt matter does it? They work either way.. I use

Re: Converting date in MySQL

On Thursday 14 October 2004 04:00 pm, Mike Johnson wrote: It does matter, though. You can't use DATE_FORMAT() to translate '10/14/2004' into '2004-10-14.' No, your right, that would be wrong. It looks like what the poster wants is STR_TO_DATE() (a la STR_TO_DATE('10/14/2004', '%m/%d/%Y'),

Release date for MySQL 4.1 Official verison

Does anybody know what the planned release date is for MySQL 4.1 Official release (not Gamma). -- Petrus Venter Hetzner Africa Tel: +27 21 970 2000 Fax: +27 21 970 2001 Email Disclaimer: http://www.hetzner.co.za/index.php?id=245 [ * Awarded Top 50 ICT Company in South Africa for the period 2003

Problems using date with MySQL 4.1.0 - Alpha

I am currently using MySQL 4.1 Win2K version along ODBC 3.5.1 Driver I am having trouble using the following LOAD DATA INFILE to import a txt, comma delimited file into to a Mysql Table. Actually the only problem is the date field loading into mysql 4.1. I have defined the field as a date,

Re: Problems using date with MySQL 4.1.0 - Alpha

At 18:10 -0600 12/14/03, Lenny Sorey wrote: I am currently using MySQL 4.1 Win2K version along ODBC 3.5.1 Driver I am having trouble using the following LOAD DATA INFILE to import a txt, comma delimited file into to a Mysql Table. Actually the only problem is the date field loading into mysql

Importing diff format date to MySQL

Hi, I have data in CSV format file which has a date value in the format 'dd/mm/yy'? When i used 'Load data...' to import to a MySQL table, all the fields gets the value from the file except the date field that contains the date of birth?? is there any way to format and import??? Thanks Regards

re: Importing diff format date to MySQL

Sankaranarayanan, Friday, October 11, 2002, 7:15:30 AM, you wrote: SM I have data in CSV format file which has a date value SM in the format 'dd/mm/yy'? SM When i used 'Load data...' to import to a MySQL table, SM all the fields gets the value from the file except the SM date field that contains

re: The Release date of MySQL 4.1

andykychan, Monday, September 23, 2002, 11:16:09 AM, you wrote: a I would like to know when the MySQL 4.1 will be released. a We are looking forwards to hearing from you. It will come in alpha before this year ends. -- For technical support contracts, goto

sysdate or curdate as default date in mysql

Dear All! Can we define sysdate or curdate as default date for a column of datatype 'date' while creating a table? Regards Sql, mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the

RE: sysdate or curdate as default date in mysql

) are performed. Mike -Original Message- From: Chugh Shalini [mailto:[EMAIL PROTECTED]] Sent: Monday, September 02, 2002 6:41 AM To: [EMAIL PROTECTED] Subject: sysdate or curdate as default date in mysql Dear All! Can we define sysdate or curdate as default date for a column of datatype

Re: sysdate or curdate as default date in mysql

Dear Chugh, Can we define sysdate or curdate as default date for a column of datatype 'date' while creating a table? The question is ambiguous: - if a table is created with a column defined to be a TIMESTAMP data type, then every time a row is INSERTed or UPDATEd, the current date will be

Re: sysdate or curdate as default date in mysql

Chugh, Monday, September 02, 2002, 3:41:27 PM, you wrote: CS Can we define sysdate or curdate as default date for a column of CS datatype 'date' while creating a table? You can't define result of function as a default value. Take a look at TIMESTAMP column type:

RE: sysdate or curdate as default date in mysql

]] Sent: Monday, September 02, 2002 9:31 PM To: [EMAIL PROTECTED] Subject:Re: sysdate or curdate as default date in mysql Chugh, Monday, September 02, 2002, 3:41:27 PM, you wrote: CS Can we define sysdate or curdate as default date

Date and Mysql...

Hi again... When I felt proud because last week I had asked about how to use NOW(), and get answer that got me working, but now I have a strange problem. It listing dates, but it not listing like it should, when the web page is create it going 9, 8, 5, 10 on the dates. Here is the SQL statement

RE: Date and Mysql...

Hi again... Hi, When I felt proud because last week I had asked about how to use NOW(), and get answer that got me working, but now I have a strange problem. It listing dates, but it not listing like it should, when the web page is create it going 9, 8, 5, 10 on the dates. Here is

Re: Date and Mysql...

Your alias and column name are the same. Which one do you think is being tested? Also DATE is a reserved word. Chuck \PUP\ Payne wrote: Hi again... When I felt proud because last week I had asked about how to use NOW(), and get answer that got me working, but now I have a strange problem. It

FW: Date and Mysql... (now complete)

(one should not mess up strg and shift :-/) Hi again... Hi, When I felt proud because last week I had asked about how to use NOW(), and get answer that got me working, but now I have a strange problem. It listing dates, but it not listing like it should, when the web page is create

Re: Date and Mysql...

»Chuck PUP Payne« sagte am 2002-04-10 um 10:27:19 -0400 : going 9, 8, 5, 10 on the dates. Here is the SQL statement I am using... That's because your DATE which you've made with DATE_FORMAT is treated as string. To fix it, I'd write: SELECT DATE_FORMAT(DATE, '%M %D, %Y') AS DATE, Title,

Simple: Date Stamp mySQL and PHP

Hi all, Ive got a timestamp in a database column and basically I was wondering if there was any function in PHP to parse the date into something more readable from 20020123143547 23 Jan 2002 14:35 something like $date1= datetoreadable($date); Thanks Shannon

Re: Simple: Date Stamp mySQL and PHP

Hi, have a look at http://www.php.net/manual/en/function.date.php According to your example, it would be something like: ?php $date1=date(d M Y H:i, 20020123143547); ? Regards Marcus Ive got a timestamp in a database column and basically I was wondering if there was any function in PHP to

Re: Simple: Date Stamp mySQL and PHP

What's this? PHP on the MySQL list - such heresy!!! Do not pass go, go directly to: http://www.mysql.com/doc/D/a/Date_and_time_functions.html =dn - Original Message - From: Marcus Müller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 24 January 2002 11:17 Subject: Re: Simple: Date

Re: Simple: Date Stamp mySQL and PHP

Oops, got it all wrong. Thought it was a real timestamp, but it's already the date, only formatted in a different way. The date() function expects a Unix-timestamp as its second argument. Thus you could try to leave the conversion to MySQL by using UNIX_TIMESTAMP(your_timestamp_column) or if you

Re: Can I use the concept of Effective Date with MySQL?

I've got the same issue that you do. Here is my thinking thus far: Say I have a transaction table: Record_Key Service_Date Item_Code Item_Quantity I'm considering this structure for the rate table: Item_Code Effective_Date Rate It's practical from a data entry perspective, but I can't seem to

Can I use the concept of Effective Date with MySQL?

I need to select the appropriate price for a product in a table, and the product has a compund key with 2 fields: product number and date. For every transaction with a certain product, I need to retrieve the price that was 'current' at the specific time when that transaction took place. In

RE: Can I use the concept of Effective Date with MySQL?

SELECT price FROM mytable WHERE price = theprice DESC LIMIT 1; -Original Message- From: Alejandro Zuzenberg [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 7:53 PM To: [EMAIL PROTECTED] Subject: Can I use the concept of Effective Date with MySQL? I need to select

RE: Can I use the concept of Effective Date with MySQL?

2001, Rick Emery wrote: Date: Thu, 1 Nov 2001 17:20:00 -0600 From: Rick Emery [EMAIL PROTECTED] To: 'Alejandro Zuzenberg' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: Can I use the concept of Effective Date with MySQL? SELECT price FROM mytable WHERE price = theprice DESC LIMIT 1

european date to mysql date

Hi, I need to transform a europe date like 10/09/2001 (dd/mm/) in this format: 2001/09/10 (/mm/dd) ... how can I do using the mysql functions? many thanks in advance max - Before posting, please check:

How can one validate a date in mysql ?

Dear Colleagues, How can one validate a date in mysql ? Kind regards, Pieter

Re: How can one validate a date in mysql ?

Validate a date? see Date and Time functions in the manual. Vankeerberghen, Pieter wrote: Dear Colleagues, How can one validate a date in mysql ? Kind regards, Pieter - Before posting, please check: http

RE: How can one validate a date in mysql ?

AM To: Vankeerberghen, Pieter Cc: [EMAIL PROTECTED] Subject: Re: How can one validate a date in mysql ? Validate a date? see Date and Time functions in the manual. Vankeerberghen, Pieter wrote: Dear Colleagues, How can one validate a date in mysql ? Kind regards, Pieter

Re: How can one validate a date in mysql ?

On Tue, May 15, 2001 at 11:27:19AM +0200, Vankeerberghen, Pieter wrote: Thank you, Ok, I looked in the manual but I coul dnot obtain an answer. How can I check that a date I'm importing is valid, e.g. how to check for 20001131 (MMDD) ? You'll have to do this kind of validation checks in

Re: How can one validate a date in mysql ?

Dear Colleagues, How can one validate a date in mysql ? Kind regards, Pieter The simplest way that i know is: date_add(datestring, interval 0 day) This function wil return the correct date or NULL with months outside 1..12 and days outside 1..31. Here are some examples: select