时间格式的转换_pgsql extract日期格式-优快云博客

本文介绍了一个通用的JavaScript函数，用于将日期格式从dd/mm/yyyy转换为数据库所需的mm/dd/yyyy格式。此函数旨在解决读取只读日期字段的问题，并确保在提交表单时能正确更新数据库。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

You may use this common js function for converting js date format "dd/mm/yyyy" to db format "mm/dd/yyyy" before db update.
The function is also desinged to help resolve the date field readonly problem.

As follows:
Common js file: common.js
// get element object in a page by its name/id
function dg(objName){
return document.getElementById(objName);
}

// copy the value of a readonly textbox to its corresponding hidden field for submission
function copyHiddenValue(objName){
    try{
        var tmp = dg(objName).value;
        // convert date from "dd/mm/yyyy" to "mm/dd/yyyy"
        // for db update
        tmp = tmp.substr(3,2)+ "/" + tmp.substr(0,2) + "/" + tmp.substr(6,4);
        dg(objName+"Hidden").value = tmp;
    }catch(e)
    {}
}

aspx file:
<script language="javascript" src="../Scripts/common.js"></script>
...
<asp:TextBox ID="txtAssignmentDate" ReadOnly="true" runat="server" MaxLength="10" ></asp:TextBox>
<img id="imgAssignmentDate" src="../Images/cal.gif" height="16" width="16" onclick="displayDatePicker('txtAssignmentDate', false, 'dmy', '/');" />
<input id="txtAssignmentDateHidden" type="hidden" runat="server" />
...
...

aspx.cs file:
btnCreate.Attributes.Add("onClick", "copyHiddenValue('txtAssignmentDate');copyHiddenValue('txtEstLostDate');");
....
strEstLostDate = txtEstLostDateHidden.Value;
...
...