The date...AGAIN!

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
snicolas
Forum Commoner
Posts: 97
Joined: Tue Nov 09, 2004 8:32 am

The date...AGAIN!

Post 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
snicolas
Forum Commoner
Posts: 97
Joined: Tue Nov 09, 2004 8:32 am

Post by snicolas »

anybody on this one?

s
Post Reply