Hi
I have a ACCESS2002 table with a date-field in format "dd-mm-yyyy"
which I "export" to a txt-file ( ; and " " )
and upload the txt-file to a MYSQL-table
where the datefield is a varchar-field.
I want to sort on the MYSQL-date-field.
How do I get a MYSQL-date-formated "yyyy-mm-dd" field
which I can sort on ??
--
Erik RN
Denmark 6 2481
First, shouldn't your mysql date field be a date field and not a varchar
field?
If it was, you don't have to export it...
instead, from within access, use odbc to link to your mysql table.
then do an append to table query to append the data from access table to
mysql table.
(one suggestion)
"Erik R.N." <fo**************@c.dk> wrote in message
news:40***********************@dtext01.news.tele.d k... Hi I have a ACCESS2002 table with a date-field in format "dd-mm-yyyy" which I "export" to a txt-file ( ; and " " ) and upload the txt-file to a MYSQL-table where the datefield is a varchar-field. I want to sort on the MYSQL-date-field. How do I get a MYSQL-date-formated "yyyy-mm-dd" field which I can sort on ??
-- Erik RN Denmark
First, shouldn't your mysql date field be a date field and not a varchar
field?
If it was, you don't have to export it...
instead, from within access, use odbc to link to your mysql table.
then do an append to table query to append the data from access table to
mysql table.
(one suggestion)
"Erik R.N." <fo**************@c.dk> wrote in message
news:40***********************@dtext01.news.tele.d k... Hi I have a ACCESS2002 table with a date-field in format "dd-mm-yyyy" which I "export" to a txt-file ( ; and " " ) and upload the txt-file to a MYSQL-table where the datefield is a varchar-field. I want to sort on the MYSQL-date-field. How do I get a MYSQL-date-formated "yyyy-mm-dd" field which I can sort on ??
-- Erik RN Denmark
First, shouldn't your mysql date field be a date field and not a varchar
field?
If it was, you don't have to export it...
instead, from within access, use odbc to link to your mysql table.
then do an append to table query to append the data from access table to
mysql table.
(one suggestion)
"Erik R.N." <fo**************@c.dk> wrote in message
news:40***********************@dtext01.news.tele.d k... Hi I have a ACCESS2002 table with a date-field in format "dd-mm-yyyy" which I "export" to a txt-file ( ; and " " ) and upload the txt-file to a MYSQL-table where the datefield is a varchar-field. I want to sort on the MYSQL-date-field. How do I get a MYSQL-date-formated "yyyy-mm-dd" field which I can sort on ??
-- Erik RN Denmark
Erik,
In Access 2002, in the design view, there is a property for the format of
each field. If you right-click on that property, there should appear a
dropdown box, with a selection of alternate formats, for that data type. If
it is not what you want, you can specifiy "YYYY-MM-DD",
(I believe if you use lower case 'mm', you will get minutes).
Best Regards,
Dana
"Erik R.N." <fo**************@c.dk> wrote in message
news:40***********************@dtext01.news.tele.d k... Hi I have a ACCESS2002 table with a date-field in format "dd-mm-yyyy" which I "export" to a txt-file ( ; and " " ) and upload the txt-file to a MYSQL-table where the datefield is a varchar-field. I want to sort on the MYSQL-date-field. How do I get a MYSQL-date-formated "yyyy-mm-dd" field which I can sort on ??
-- Erik RN Denmark
Erik,
In Access 2002, in the design view, there is a property for the format of
each field. If you right-click on that property, there should appear a
dropdown box, with a selection of alternate formats, for that data type. If
it is not what you want, you can specifiy "YYYY-MM-DD",
(I believe if you use lower case 'mm', you will get minutes).
Best Regards,
Dana
"Erik R.N." <fo**************@c.dk> wrote in message
news:40***********************@dtext01.news.tele.d k... Hi I have a ACCESS2002 table with a date-field in format "dd-mm-yyyy" which I "export" to a txt-file ( ; and " " ) and upload the txt-file to a MYSQL-table where the datefield is a varchar-field. I want to sort on the MYSQL-date-field. How do I get a MYSQL-date-formated "yyyy-mm-dd" field which I can sort on ??
-- Erik RN Denmark
Erik,
In Access 2002, in the design view, there is a property for the format of
each field. If you right-click on that property, there should appear a
dropdown box, with a selection of alternate formats, for that data type. If
it is not what you want, you can specifiy "YYYY-MM-DD",
(I believe if you use lower case 'mm', you will get minutes).
Best Regards,
Dana
"Erik R.N." <fo**************@c.dk> wrote in message
news:40***********************@dtext01.news.tele.d k... Hi I have a ACCESS2002 table with a date-field in format "dd-mm-yyyy" which I "export" to a txt-file ( ; and " " ) and upload the txt-file to a MYSQL-table where the datefield is a varchar-field. I want to sort on the MYSQL-date-field. How do I get a MYSQL-date-formated "yyyy-mm-dd" field which I can sort on ??
-- Erik RN Denmark
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: mustafa |
last post by:
Dear sir ,
I have built my application in visual basic 6.0 and
crystal Report8.5 , Now i migrated my application to
VB.net using the upgrade wizard.My visual basic form is
upgraded to vb.net...
|
by: Armand Karlsen |
last post by:
I have a website ( http://www.zen62775.zen.co.uk ) that I made HTML 4.01
Transitional and CSS compliant, and I'm thinking of converting it into XHTML
to learn a little about it. Which XHTML variant...
|
by: prabha |
last post by:
Hello Everybody,
I have to conert the word doc to multiple html files,according to the templates in the word doc.
I had converted the word to xml.Also through Exsl ,had finished the multiple...
|
by: Robert |
last post by:
I have a series of web applications (configured as separate applications) on
a server.
There is a main application at the root and then several virtual directories
that are independant...
|
by: Mary |
last post by:
Hi,
Does anyone know of any software out there that would convert an application
written in VBScript to either VB.NET or C#/C++ quite quickly for me, or will
I have to re-write the application...
|
by: Map Reader |
last post by:
Greetings,
I am converting an old VB6 application to use .NET. One of the old controls
loads icons from the disk and displays them. However, the transparent color
turns to blue somewhere in the...
|
by: Frederik Vanderhaeghe |
last post by:
Hi,
I have a problem converting text to a double. Why doesn't the code work:
If Not (txtdocbedrag.Text = "") Then
Select Case ddlBedrag.SelectedIndex
Case 0
Case 1
|
by: Tor Aadnevik |
last post by:
Hi,
I have a problem converting values from Single to double.
eg. When the Single value 12.19 is converted to double, the result is
12.1899995803833.
Anyone know how to avoid this?
Regards...
|
by: gg9h0st |
last post by:
i'm a newbie studying php.
i was into array part on tutorial and it says
i'll get an array having keys that from member variable's name
by converting an object to array.
i guessed "i can...
|
by: shenanwei |
last post by:
DB2 V8.2 on AIX, type II index is created.
I see this from deadlock event monitor.
5) Deadlocked Connection ...
Participant no.: 2
Lock wait start time: 09/18/2006 23:04:09.911774
.........
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |