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 |
|
elliebg
Starting Member
1 Post |
 Posted - 2008-02-25 : 13:18:18
|
Hi all,I am writing a database for a sport club. In order to be able to show reports for achievements I need to break apart the datetime format in SQL.Example table with columns:1)Date of competition ||| 2)Time achieved by competitor for 100m(in format mm:ss.fff, minutes:seconds.hundreds)| 01/01/2008 ||| 00:15.231 || 01/02/2008 ||| 00:12.543 || 01/03/2008 ||| 00:15.332 |Then I need to show this in a graph with axis X Date and axis Y Time to show personal development for the whole year.I do not want to CONVERT to VARCHAR because it won’t be possible to compare in the graph. Please helpThank you.Ellie |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-25 : 13:43:20
|
| How about convert it to julian format? |
 |
|
|
|
|
|
how to break apart the datetime