|
02-03-2005, 03:52 AM
|
#1 |
|
Junior Member
Join Date: Feb 2005
Posts: 1
|
Importing Time Data - Issues
Hello,
We have a VB application that imports timesheet data into a MYSQL database. Everything works fine until you try and import a time between midnight and 1am. An example is that 0:45 gets imported at 45:00. Can anybody offer any help or advise on how to resolve this. Many thanks Nick |
|
|
|
02-05-2005, 08:40 AM
|
#2 |
|
Senior Member
Join Date: Jul 2004
Posts: 167
|
Re: Importing Time Data - Issues
Date and Time formats are a real pain in the ass, but if you look closely at the mysql documentation under their date section, it will give you the answer. But first test the data. It gives you date formats. Compare what the date field looks like in your table, then do a SELECT dateformat date to see what it looks like before trying it on real data. Also, replace dateformat with what you read in the docs and date with a datetime you are having problems with.
|
|
|
|
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Data Corruption using navicat | webie | Navicat Support | 1 | 08-19-2005 02:12 PM |
| Limiting Data to specific format | kfschaefer | Database Design | 2 | 12-01-2004 05:05 AM |
| Import Access, Excel and data of other formats to MySQL by Navicat | NavicatGuy | Articles | 0 | 08-17-2004 01:08 AM |
| 3.3 Creating and Using a Database | Administrator | Documentation | 13 | 06-09-2004 04:56 PM |
| 2 Installing MySQL | Administrator | Documentation | 103 | 06-09-2004 02:53 AM |
