导入excel时的时间格式显示

[湖中仙人]

我将一张数据表导入excel时我想将其中的时间列,如:2008-10-10显示为10-Oct-08怎么做??

[水如烟]

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim s As String = "2008-10-10"
        Dim result As String = GetEnDateTime(s)
        Console.WriteLine(result)'10-Oct-08
        result = GetEnDateTime(Now)
        Console.WriteLine(result)'05-Dec-08
    End Sub

    Public Function GetEnDateTime(ByVal input As String) As String
        Return GetEnDateTime(DateTime.Parse(input))
    End Function

    Public Function GetEnDateTime(ByVal input As DateTime) As String
        Return input.ToString("dd-MMM-yy", New Globalization.CultureInfo("en-US", False).DateTimeFormat)
    End Function

[jinjazz]

你是用什么方式导入到excel的？

[qinhl99]

如果你是去构造一个sql的话,这很好办的!

[Ny-6000]

友情帮顶。

[wangsong145]

可以试试 format