Access and asp about the time format, please tell me if you know!

Three methods. 1. Modify the database (the easiest way) method: open the data table-design view-rq field.

In the following property bar, enter yyyy-mm-dd in the -General Item-Format, and everything is OK

No other operations, no need to change the above!

Second, when the data is exported. (Your write ** does not change, and the output date is written like this) three, when the data is written, (modify the ** above, the output ** does not change).

That's what I wrote:

yy=year(rs("date"))

mm=month(rs("date"))

dd=day(rs("date"))

if mm<10 then mm="0"&mmif dd<10 then dd="0"&dddate=yy&"-"&mm&"-"&dd If there's a better way, I'd also really like to know, learn it.

I'll do it, so it's ok! Oh also

Depending on which section is being used, Access provides several different ways to format the date. On forms and reports in desktop databases, dates are typically displayed in text boxes. Simply set the Format property of the text box to the desired date format.

In layout view or design view, press F4 to display the Attribute Table, and then set the Format property to one of the predefined date formats:

Optionally, enter a custom date format.

The Access application is displayed in"view", with data in a text box similar to a form in a desktop database. However, instead of the attribute table, the formatting options are displayed by selecting the text box and then clicking the Format button. Then, select the desired format from the list of formats.

Hello, very glad for your question :

Since the information provided is not sufficient, it can be difficult to discern what kind of problem you are having.

When using SQL Execute to perform database operations, the syntax is required to be very strict, and for the sake of writing habits, usually, database fields and the like should not be represented in Chinese as much as possible to prevent low recognition.

You may wish to review your question from the following questions:

1. Try changing the Deadline to:'Deadline'(plus single quotation marks for a string).

2. I don't know if Z ID is a parameter passed by URL? If so, you should use request("z_id"Receive the Tan Ant line.

3. You can try this way: where id="&z id) to where id="&z_id&""

4. Check whether the name value of the form item is consistent with jzrq.

5. What is the input method of your voice? Is it a text box? The test object is spine"jzrq") to request("jzrq"Take a look.

Hope you help!

"update gbllxxj set deadline='You Chunbo"&"jzrq"& pants rotten'Shenxiang where id="&z_id)