DateTime Function

[tanya_1985_am]

In my database I have field named dateTime and in the web page i want to display the date in one column and the time in another. E.g.

dateTime = 01/01/2001 01.30.00

In the table i want to see

date - 01/01/2001
time - 01.30.00

How do i do this i have spent hours searching the internet and this is my last resort. The people this site is for want to keep the database field as it is shown above. So the easy answer is gone!

Any comments will be appreciated

Tanya

[Jacque]

If I have understood your questions right, I think you could just simply use the following DateTime-functions:

Year, Month, Day, Hour, Minute and Second.

With these functions you can extract the relevant part of your DateTime data and easily reconstructed it in the way you want. For example:

Date = Day(DateTime) & Month(DateTime) & Year(DateTime)
Time = Hour(DateTime) & Minute(DateTime) & Second(DateTime)

You may also want to check if the values resulting from the functions Day, Month, Hour, Minute and Second are less than 10 so that to prefix a Zero. In this way you ensure that dates and times are presented in the correct format (dd/mm/yyy and hh:mm:ss). For example 01/01/2006 and not 1/1/2006.

I hope this helps you.

Sincerely
Jacque

[iedayu7579]

Originally Posted by Jacque

If I have understood your questions right, I think you could just simply use the following DateTime-functions:

Year, Month, Day, Hour, Minute and Second.

With these functions you can extract the relevant part of your DateTime data and easily reconstructed it in the way you want. For example:

Date = Day(DateTime) & Month(DateTime) & Year(DateTime)
Time = Hour(DateTime) & Minute(DateTime) & Second(DateTime)

You may also want to check if the values resulting from the functions Day, Month, Hour, Minute and Second are less than 10 so that to prefix a Zero. In this way you ensure that dates and times are presented in the correct format (dd/mm/yyy and hh:mm:ss). For example 01/01/2006 and not 1/1/2006.

I hope this helps you.

Sincerely
Jacque

Hi Jacque,

I'm facing a problem to change my date format from eg : 1/July/2006 to 01/July/2006.

Tried to change setting the control panel but the result still the same.

Hope you can help.

[poonam]

hello to all

[poonam]

Originally Posted by poonam

hello to all

[Monie]

Originally Posted by tanya_1985_am

In my database I have field named dateTime and in the web page i want to display the date in one column and the time in another. E.g.

dateTime = 01/01/2001 01.30.00

In the table i want to see

date - 01/01/2001
time - 01.30.00

How do i do this i have spent hours searching the internet and this is my last resort. The people this site is for want to keep the database field as it is shown above. So the easy answer is gone!

Any comments will be appreciated

Tanya

Hai tanya,
You can perform 2 function to get it. One for date, and one for time. you also have to create 2 field in your database to store the date and time.
I have with me an example of date function in asp that might help you,
This will display dd/mm/yyyy (eg: 01/12/2007)

HTML: Select all

<%
        dim dd,mm,yyyy,date
        dd=day(date)
        if len(dd)=1 then
          dd="0" & dd
        end if
        mm=month(date)
        if len(mm)=1 then
          mm="0" & mm
        end if
        yyyy=year(date)
        
        'getting new date
        date = dd & "-" & mm & "-" & yyyy
        Session("date") = date
        response.write Session("date") 'to display the date in your page
        response.end
%>

you could write:

Code: Select all

<%
Dim date, time
date = Session("date")
time = time()
%>

after that you can perform the INSERt INTO function to insert the value to the database according to their field.