John Lange ( radadmin@palacenet.net )
Wed, 05 Jan 2000 12:52:42 -0600

HI & Thanks for Your Help

I have been trying to learn to write my own SQL queries, and have been
successful to a point. I just cannot seem to get the "smalldate" format

select * into calls2 from calls where acctstatustype = 2 and calldate >
January 01 2000 00:01AM order by calldate

This statement ALWAYS errors out on 01 and will go no further. How is
"smalldate" supposed to be formated?

Thanks Again
JOhn :}

----- Whatever you do, work at it with all your heart, as working for the
Lord, not for men >Colossians 3:23 (NIV)

John C. Lange, Sr. PALACE dot NET, INC.
microjl@palacenet.net MICRO-TECH Computers, Inc.
608.742.1601 & 6980 1819 New Pinery Road
http://www.palacenet.net/ Portage, WI 53901
MSCE Training for only $150.00 - http://dpec.palacenet.net/
All 200+ Web Based Courses for $150.00 Per Year - "Really"

--- __o
--- _-\<,_ Fastest Service in Town
--- (_)/ (_)

For more information about this list (including removal) go to: