Justin,
Where are you getting the date/time that you are using to update the entries
into your database? If you only use the date, rather than the date/time
when you insert into the database, then time will be filled as zeros. I'm
not sure why you'd want to change this though. If a date is stored with
date and time, you can just ignore the time portion when manipulating the
dates.
Bob
-----Original Message-----
From:
sentto-1241504-5731-978117134-robert_ladd=compuserve.com@returns.onelist
.com
[mailto:sentto-1241504-5731-978117134-robert_ladd=compuserve.com@returns
.onelist.com]On Behalf Of Justin Wilson
Sent: Friday, December 29, 2000 12:17 PM
To: 'azipa@egroups.com'
Subject: [azipa] SQL question
I have a simple SQL question for anyone that knows SQL. I am trying to time
date stamp entries that are made through one of our websites, Currently I
have it using date and time stamp. Is there a way to stamp these entries
with just the date?
-Justin
justin@labxpress.com
==AZIPA=============================================================
Arizona Internet Professionals Association http://www.azipa.org
Next AZIPA monthly meeting is 5:30pm on Monday, January 22nd, 2001
Please be sure to RSVP! http://www.acteva.com/go/azipa
Other upcoming events:
Tempe Tech Oasis Techie Tuesday - 6:00pm, Tuesday 1/9/01
Beeloe's Cafe & Bar, 501 S. Mill Ave Tempe (SE corner of 5th)
Strategic Research Institute Web Launch BootCamp - 1/30-2/2/01
http://www.srinstitute.com/cx326
=============================================================AZIPA==
==AZIPA=============================================================
Arizona Internet Professionals Association http://www.azipa.org
Next AZIPA monthly meeting is 5:30pm on Monday, January 22nd, 2001
Please be sure to RSVP! http://www.acteva.com/go/azipa
Other upcoming events:
Tempe Tech Oasis Techie Tuesday - 6:00pm, Tuesday 1/9/01
Beeloe's Cafe & Bar, 501 S. Mill Ave Tempe (SE corner of 5th)
Strategic Research Institute Web Launch BootCamp - 1/30-2/2/01
http://www.srinstitute.com/cx326
=============================================================AZIPA==