Professional Web Applications Themes

cast from datetime type to smalldatetime type? - ASP.NET General

Hi, How can I cast from datetime type to smalldatetime type. I get the records from a table which has got a datetime type column but I want to display it smalldatetime format. Thanks, Salim...

  1. #1

    Default cast from datetime type to smalldatetime type?

    Hi,
    How can I cast from datetime type to smalldatetime type.
    I get the records from a table which has got a datetime type column but I
    want to display it smalldatetime format.
    Thanks,
    Salim


    Salim Afar Guest

  2. #2

    Default Re: cast from datetime type to smalldatetime type?

    I think you can use something like:

    response.write(dMyLongDate.tostring("dd/MM/yy"))

    Regards,

    Stu


    "Salim Afar" <safsarluckyeye.com> wrote in message
    news:%231j6NMDWDHA.2228TK2MSFTNGP12.phx.gbl...
    > Hi,
    > How can I cast from datetime type to smalldatetime type.
    > I get the records from a table which has got a datetime type column but I
    > want to display it smalldatetime format.
    > Thanks,
    > Salim
    >
    >

    ---
    Outgoing mail is certified Virus Free.
    Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
    Version: 6.0.505 / Virus Database: 302 - Release Date: 30/07/2003


    Stu Guest

  3. #3

    Default Re: cast from datetime type to smalldatetime type?

    Not like that:
    I get it with sql string.I want to do something like that :

    select format(mydate,("dd/MM/yy"),.... from myTable

    Thanks a lot

    "Stu" <stuartntpcl.uk.com> wrote in message
    news:u2I$BVDWDHA.1352TK2MSFTNGP10.phx.gbl...
    > I think you can use something like:
    >
    > response.write(dMyLongDate.tostring("dd/MM/yy"))
    >
    > Regards,
    >
    > Stu
    >
    >
    > "Salim Afar" <safsarluckyeye.com> wrote in message
    > news:%231j6NMDWDHA.2228TK2MSFTNGP12.phx.gbl...
    > > Hi,
    > > How can I cast from datetime type to smalldatetime type.
    > > I get the records from a table which has got a datetime type column but
    I
    > > want to display it smalldatetime format.
    > > Thanks,
    > > Salim
    > >
    > >
    >
    >
    > ---
    > Outgoing mail is certified Virus Free.
    > Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
    > Version: 6.0.505 / Virus Database: 302 - Release Date: 30/07/2003
    >
    >

    Salim Afar Guest

Similar Threads

  1. how to type cast getjsobject form vb.net to c#
    By shashikala@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 1
    Last Post: July 19th, 06:43 AM
  2. SQL Server DateTime Data Type
    By dpinder123 in forum Coldfusion Database Access
    Replies: 1
    Last Post: September 2nd, 04:11 PM
  3. Cast from type 'Field' to type 'String'
    By in forum ASP Database
    Replies: 2
    Last Post: November 11th, 03:18 PM
  4. <<Error converting data type char to smalldatetime>>
    By Gary D. Rezek in forum ASP Database
    Replies: 9
    Last Post: September 17th, 06:57 PM
  5. Cast from type 'DBNull' to type 'String' is not valid error
    By Rob in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: July 28th, 09:11 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139