ASP and Access DateTime

[RushiShroff]

I have a table in access 2000 DB in which there is a field
"Account_Created_Date".I have given datatype "DateTime"

Now I want to insert Time along with Date while account is created.How can I do it with SQL/ASP script?

Regards
X-)

 

[Ovatvvon]

same things as any other data you are entering into the database. Just assign the server date/time value to a variable to be inserted with the rest of your data...

Dim AccountStart
AccountStart = now()
'will assign the date and time as of Right Now!


Hope this helps! -Ovatvvon :-Q

 

[RushiShroff]

NoW I have inserted DateTime using Now() in the ACCess DB.
How can I seperate them ?
That is while retriving how can I seperate time fraction ?

Regards

 

[Ovatvvon]

To format your date input from the database, on your output use the formatDateTime() function. You can pull and display your db value in one of several ways:

------------------------------------------------


formatDateTime(now(),0) = 2/2/2002 1:36:55 AM
This shows just as it is in the db.


formatDateTime(now(),1) = Saturday, February 02, 2002
Long Date


formatDateTime(now(),2) = 2/2/2002
Short Date


-------------------------------------------


formatDateTime(now(),3) = 1:38:41 AM
12 Hour Clock


formatDateTime(now(),4) = 01:35
24 Hour Clock


-------------------------------------------


Additionally, you can pull direct fields from the value using Month(), Day(), Year(). If you were to write,

Response.write Month(now()) & "/" & Day(now()) & "/" & Year(now())

the output would be 2/2/2002

or you can pull time elements like so,

Response.write Hour(now()) & " " & Minute(now()) & " " & Second(now())

Which will produce 1 50 15


You can get more reference to these functions at:

http://msdn.microsoft.com/library/d...n-us/foxhelp98/catdate_and_time_functions.asp

Hope this helps! -Ovatvvon :-Q

 

[RushiShroff]

Thanks,
Ovatvvon
so nice of you...

Regards