Excel Date Julian SQL conversion

[SubFire]

EXCEL Text Cell formating write : 38617
EXCEL date Cell formating write : 2005-09-22

My problem was some date are write :
JJ-MM-YYYY
MM-JJ-YYYY
JJ-MM-YY
MM-JJ-YY
YYYY-MM-JJ
YY-MM-JJ

Some other are write in French or in English letter !!!!

* Thank to my friendly user !


My solution is :
Put all row in the columns in text cell format.
Drop it in a DB ( because the my final goal )
Convert them with SQL language ( My favorite EVER )
Hope that is the correct date LOL

SQL CONVERT :


SELECT now(*)-(datediff( day, '1900/01/01', now(*)) -EXCELDATENUMBER +2)

ANSWER : DATETIME value !
(the time are not important for me so I don't boarder. )


EX :
SELECT now(*)-(datediff( day, '1900/01/01', now(*)) -38617 +2)

ANSWER : 2005-09-22 XX:XX:XX.XXX