Page 1 of 1

The date...AGAIN!

Posted: Tue Dec 21, 2004 6:06 am
by snicolas
HI Guys,

I am using MSSQL (not mysql) and have problem with dates...(yes i know!)

I succesfully display the date the way i want from the data stored in my DB using this.
select *,CONVERT(char(10), [date], 105)AS date etc....

This date is displayed in a <input> and users are allowed to edit it.
This is where the problem starts.
As i convert my date succesfully to display it, how can I:
1/ Check back fro correct date format
2/ Update my MSSQL field with the correct date format?

I already had a look at:
http://www.databasejournal.com/features ... _2197931_2
and
http://www.epsilon-logic.net/OQBHelpDoc ... ctions.htm

looking more for an answer than aguidance!

thanks in advance

s

Posted: Tue Dec 21, 2004 11:12 am
by snicolas
anybody on this one?

s