如何用js写一个将数字类型转换为时间类型的函数

Question

数据库里面的注册时间是数字类型，因要显示在网站后台，所以要将这个时间字段用Gridview绑定，但是绑定出来的是数字，如何将其数字类型转换成时间类型绑定出来！求一js代码

Answer 1

是一个数字是从1970年到现在秒数，用javascript可以获得(javascript中使用的是毫秒数,相差1000)，如today = new Date();document.write("现在是:",today.getTime()); 也可设置时间  today.setTime(1124453309750);document.write("所设时间年份是:",today.getYear())

Answer 2

这个用js弄不蛋疼吗?可以直接在数据库处理的啊declare @dt bigint
set @dt = 1124453309750;--毫秒数，如果是秒，下面的1000可以不用除
select dateadd(ss,@dt/1000,cast('1970-1-1' as datetime))

Answer 3

你查询出来可以select dateadd(ss,放数字的字段/1000,cast('1970-1-1' as datetime))  as dt,* from tb

Answer 4

<script>
/**
 * time(时间戳)
 * type(0-显示年、月、日，1-显示年、月、日、时、分、秒)
 * separator1(用来分隔年月日)
 * separator2(用来分隔时分秒)
 *
 */
function date_format(time, type, separator1, separator2){ var TExp = /\d{13,13}/;
if(!TExp.test(time))return false;
if(separator1 == undefined)separator1 = "-";
if(separator2 == undefined)separator2 = ":";
var D = new Date(time);
var y = D.getFullYear();
var m = D.getMonth() + 1;
var d = D.getDate();
var h = D.getHours();
var i = D.getMinutes();
var s = D.getSeconds(); time = y + separator1 + m + separator1 + d;
if(type){
time += " " + h + separator2 + i + separator2 + s;
}

return time;}
var time = Date.parse(new Date());
var format_time = date_format(time, 1);
alert(format_time);
</script>

Answer 5

var m = D.getMonth() + 1 < 10 ? "0" + (D.getMonth() + 1) : D.getMonth() + 1;

Answer 6

你可以按照这个思路去，那个字段里是放1970到指定日期的秒数
那可以用
1970年+秒数=要得到的日期
sql 中有个dateadd函数，可以研究下
http://www.w3school.com.cn/sql/func_dateadd.asp

Answer 7

    <script type="text/javascript">
   function getTime(i)
   {        
        today = new Date();
        document.write("现在是:",today.getTime());
        today.setTime(i*1000);
        document.write("所设时间年份是",today.getYear(),"/",today.getMonth(),"/",today.getDay())
   }
   </script>这个可以用作时间的转换，但是这段JS代码怎么放在绑定数据中<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="UIN" Width="100%" CellPadding="3" CellSpacing="1"
                GridLines="None" BorderWidth="0px" OnRowCommand="GridView1_RowCommand" OnRowDataBound="GridView1_RowDataBound">
                <Columns>
                    <asp:TemplateField>
                        <HeaderTemplate>
                            <asp:CheckBox ID="CheckBox1" runat="server" onclick="javascript:SelectAll(this);"
                                Text="全选" />
                        </HeaderTemplate>
                        <ItemTemplate>
                            <asp:CheckBox ID="CheckBox2" runat="server" Text="选择" />
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:BoundField DataField="UIN" HeaderText="编号" InsertVisible="False" ReadOnly="True"
                        SortExpression="UIN" />                   
                    <asp:TemplateField>
                        <ItemTemplate>
                           <%#Eval("UserName")%>
                        </ItemTemplate>
                        <HeaderTemplate>
                            用户名
                        </HeaderTemplate>
                    </asp:TemplateField>
                    <asp:BoundField DataField="Nick" HeaderText="昵称" SortExpression="Nick" />
                    <asp:BoundField DataField="bOnline" HeaderText="在线状态" SortExpression="bOnline" />
                    <asp:BoundField DataField="nRegisterTime" HeaderText="注册时间" SortExpression="nRegisterTime" />
                    <asp:BoundField DataField="nExpireTime" HeaderText="过期时间" SortExpression="nExpireTime" />
                    <asp:BoundField DataField="nLoginTimes" HeaderText="登录次数" SortExpression="nLoginTimes" />
                    <%--<asp:BoundField DataField="nLastLoginTime" HeaderText="上次登录时间" SortExpression="nLastLoginTime" />--%>
                    <asp:TemplateField>
                       <ItemTemplate>  
                           <asp:Label ID="Label2" runat="server" Text='<%#Eval("nLastLoginTime")%>'></asp:Label>
                       </ItemTemplate>
                       <HeaderTemplate>上次登录时间</HeaderTemplate>
                    </asp:TemplateField>
                    
                    <asp:BoundField DataField="onlineTime" HeaderText="在线时长" SortExpression="onlineTime" />
                    <asp:BoundField DataField="nEnableStatus" HeaderText="启用状态" SortExpression="nEnableStatus" />
                    <asp:BoundField DataField="money" HeaderText="余额" SortExpression="money" />  
                    <asp:BoundField DataField="nEnableStatus" HeaderText="IP" SortExpression="nEnableStatus" />
                    <asp:BoundField DataField="sIP" HeaderText="端口" SortExpression="sIP" />  
                    <asp:BoundField DataField="sAuth" HeaderText="权限" SortExpression="sAuth" />  
                    <asp:TemplateField HeaderText="编辑">
                        <ItemTemplate>
                            <a href="Edit.aspx?UIN=<%#Eval("UIN") %>">编辑</a>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="删除">
                        <ItemTemplate>
                            <asp:LinkButton ID="LinkButton1" CommandName="del" runat="server" CommandArgument='<%# Eval("UIN") %>' OnClientClick='return confirm("确定要删除吗？");'>删除</asp:LinkButton>
                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>
                <RowStyle HorizontalAlign="Center" CssClass="tr1" />
                <AlternatingRowStyle HorizontalAlign="Center" CssClass="tr2" />
                <HeaderStyle CssClass="th" />
            </asp:GridView>