Re: [DUG]: SQL Dates/Times

1999-07-07 Thread Tony Blomfield
but then what do you expect from MS) -Original Message- From: Mark Derricutt <[EMAIL PROTECTED]> To: Multiple recipients of list delphi <[EMAIL PROTECTED]> Date: Thursday, 8 July 1999 11:21 Subject: Re: [DUG]: SQL Dates/Times --On Thursday, July 08, 1999, 11:11 AM +1200 Mark De

Re: [DUG]: SQL Dates/Times

1999-07-07 Thread BJ Wilson
uly 1999 11:15 Subject: Re: [DUG]: SQL Dates/Times --On Thursday, July 08, 1999, 11:11 AM +1200 Mark Derricutt <[EMAIL PROTECTED]> wrote: > Whats the correct formatting for a date/time combination in SQL? "1-Jan-1998 12:30:00 AM" works :-) w00p.

Re: [DUG]: SQL Dates/Times

1999-07-07 Thread Mark Derricutt
--On Thursday, July 08, 1999, 11:11 AM +1200 Mark Derricutt <[EMAIL PROTECTED]> wrote: > Whats the correct formatting for a date/time combination in SQL? "1-Jan-1998 12:30:00 AM" works :-) w00p. --- New Zealand Delphi U

[DUG]: SQL Dates/Times

1999-07-07 Thread Mark Derricutt
After the recent discussion on formatting dates for SQL, I've just come accross a similiar need, however, I need to use a date/time in sql to search on a timestamp field. Whats the correct formatting for a date/time combination in SQL? -- Mark Derricutt ---