/* Create a table we can experiment with.
 * NOTE: Sybase does not have a separate
 *       DATE datatype.
 */
CREATE TABLE
   test004 (my_date DATETIME)
GO

/* Insert December 5, 2000 */
SET dateformat mdy
GO
INSERT INTO test004 VALUES('12/5/2000')
GO

/* Insert May 12, 2000 */
SET dateformat dmy
GO
INSERT INTO test004 VALUES('12/5/2000')
GO