Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kiana
Starting Member
2 Posts |
 Posted - 2005-03-28 : 04:23:12
|
| Hi there,I am not too sure how to put this accross, but i will try to be as detailed as possible to my query here.Trying to build a prototype db with mysql currently and I am trying to import a flat file to the db. The flat file contain 2 time values which needs to be inserted into different column and has to be subtracted to obtain the time difference.Example:-Time A Time B2005-03-21/23:59:48 2005-03-22/00:00:00Question.1. What DATE format do i create the columns to be for Time A and Time B to accept these values? Or do i need to pre-filter the flat file to another format so that the db can accept easily?2. How to obtain the time difference between Time A and Time B?Appreciate any form of help and suggestions. TIA!i bite |
|
|
SqlStar
Posting Yak Master
121 Posts |
Posted - 2005-03-28 : 05:55:10
|
| Are you asking solution from MySQL? If you want to get solution from SQL Server, we may help you.:) While we stop to think, we often miss our opportunity :) |
 |
|
|
kiana
Starting Member
2 Posts |
Posted - 2005-03-28 : 15:46:09
|
| Yes, SqlStar you are Right!Helps pls? Thanks! Need advise to get going..i bite |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-28 : 15:50:06
|
| This is a MS SQL Server forum; I'd suggest posting your question in a mysql forum such as:http://www.dbforums.com/f5Tara |
|
|
|
|
|
|
Newbie needs help with DATE