Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. can we store date time in millisecond formate(

can we store date time in millisecond formate(

Scheduled Pinned Locked Moved ASP.NET
8 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • P Offline
    P Offline
    Piyush Vardhan Singh
    wrote on last edited by
    #1

    can we store date time in millisecond formate(2007/11/13 02:20:36:265) in ms access

    Piyush Vardhan Singh

    S I 2 Replies Last reply
    0
    • P Piyush Vardhan Singh

      can we store date time in millisecond formate(2007/11/13 02:20:36:265) in ms access

      Piyush Vardhan Singh

      S Offline
      S Offline
      Sonia Gupta
      wrote on last edited by
      #2

      i think , the access date/time data type by default only stores the time to the second.My suggestion is , u take another field to store the milliseconds.

      Soniagupta1@yahoo.co.in Yahoo Messenger Id = soniagupta1

      P 1 Reply Last reply
      0
      • S Sonia Gupta

        i think , the access date/time data type by default only stores the time to the second.My suggestion is , u take another field to store the milliseconds.

        Soniagupta1@yahoo.co.in Yahoo Messenger Id = soniagupta1

        P Offline
        P Offline
        Piyush Vardhan Singh
        wrote on last edited by
        #3

        thanks for suggestion. i have done this work yesterday. only i want to conform.

        Piyush Vardhan Singh

        I 1 Reply Last reply
        0
        • P Piyush Vardhan Singh

          can we store date time in millisecond formate(2007/11/13 02:20:36:265) in ms access

          Piyush Vardhan Singh

          I Offline
          I Offline
          InsDev
          wrote on last edited by
          #4

          first change the column property to text and then use this format in input mask 00:00:00:000\(A"M)";0;_ will solve ur problem. Devjit Das.

          P 1 Reply Last reply
          0
          • P Piyush Vardhan Singh

            thanks for suggestion. i have done this work yesterday. only i want to conform.

            Piyush Vardhan Singh

            I Offline
            I Offline
            InsDev
            wrote on last edited by
            #5

            u have wast my time. Devjit Das.

            1 Reply Last reply
            0
            • I InsDev

              first change the column property to text and then use this format in input mask 00:00:00:000\(A"M)";0;_ will solve ur problem. Devjit Das.

              P Offline
              P Offline
              Piyush Vardhan Singh
              wrote on last edited by
              #6

              i am sending input like this can u modified this which format MS AccESS acept INPUT:- Now.ToString("yyyy/MM/dd,hh:mm:ss:") & Now.Millisecond.ToString

              Piyush Vardhan Singh

              I 1 Reply Last reply
              0
              • P Piyush Vardhan Singh

                i am sending input like this can u modified this which format MS AccESS acept INPUT:- Now.ToString("yyyy/MM/dd,hh:mm:ss:") & Now.Millisecond.ToString

                Piyush Vardhan Singh

                I Offline
                I Offline
                InsDev
                wrote on last edited by
                #7

                use text format. Devjit Das.

                P 1 Reply Last reply
                0
                • I InsDev

                  use text format. Devjit Das.

                  P Offline
                  P Offline
                  Piyush Vardhan Singh
                  wrote on last edited by
                  #8

                  how to use Distinct in ms access i want to count distinct starttime from table

                  Piyush Vardhan Singh

                  1 Reply Last reply
                  0
                  Reply
                  • Reply as topic
                  Log in to reply
                  • Oldest to Newest
                  • Newest to Oldest
                  • Most Votes


                  • Login

                  • Don't have an account? Register

                  • Login or register to search.
                  • First post
                    Last post
                  0
                  • Categories
                  • Recent
                  • Tags
                  • Popular
                  • World
                  • Users
                  • Groups