Bookham Measures wrote:
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcomwrote in message
news:u%****************@TK2MSFTNGP05.phx.gbl...
>Evertjan. wrote:
>>submittime = timevalue(submitdate)
!
Never saw that one!
And of course, there's a DateValue function I've never used!
Although you'd want TimeValue.
Huh?
Oh, I see. No, I was only pointing out the existance of DateVale, not
suggesting its use in this situation.
>
The 1899 date is always how SQL stores time only values.
:-)
Why is what "SQL" does relevant? We are discussing only vbscript
variables and functions here. How SQL stores datetimes is irrelevant.
:-)
Also, the seed date used does vary depending on the database being used.
For example, I believe Jet uses 1/1/1900 - I may be wrong, and I don't
have time to go check it, but I do know it's a different seed date than
what SQL Server uses.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.