Date problem.

Ranch Hand

Posts: 72

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Can anyone tell me how I can enter following data in publisher table?

PublishID, PublishDate, AuthId
111, 07-06-05, SSS

It is giving problem with entering the date value.

Thanks.

Jan Cumps

Bartender

Posts: 2662

I like...

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

As '05-JUN-2007', or as to_date('07-06-05','RR-MM-DD')
Take care with 2 digit years. Before you know it, the next millennium arrives.
Regards, Jan

OCUP UML fundamental and ITIL foundation

Suman Sharma

Ranch Hand

Posts: 72

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Thanks for your help.

Did you see how Paul cut 87% off of his electric heat bill with 82 watts of micro heaters?