Problem with date 1/1/1900
While waiting on a response from the sys admin, I decided to post this question.
I have a script (ASP/MSSQL - don't ask why) that allows users to post rental property they have. As a base, I used Enthrallweb's script (ASP/Access). Anyway, my script requires that each poster's entry sends information to the database on the current date and the current date + 90 days (expiration).
I use the ASP getdate() which sends information to the database just fine, but this information is always 1/1/1900. Is there something I can do to make sure the Internet time isnt' given, but instead the local time is?
Thanks in advance.
CPRhosting.com - CPR Hosting...Giving life to the web
Custom-made Hosting Plans starting at $2
druagord posted this at 21:11 — 11th June 2003.
He has: 335 posts
Joined: May 2003
i didn't touch ASP for more then a year so i might be wrong but i think you should use getdate(now()) or something similar
shanda posted this at 01:02 — 30th July 2003.
They have: 105 posts
Joined: Jan 2002
I'm sure some folks will run into this in the future, so I guess I should post my solution.
Since it was on a Windows machine, I figured case-sensitivity wasn't an issue. I was wrong. The correct format is either GETDATE() or getDate().
Go figure.
CPRhosting.com - CPR Hosting...Giving life to the web
Custom-made Hosting Plans starting at $2
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.