timestamp

How to get a timestamp for curent time?

Nov 20 '05 #1

43284

Dim tm As System.DateTime
tm = Now

"Crirus" <Cr****@datagroup.ro> wrote in message
news:e3****************@TK2MSFTNGP09.phx.gbl...

How to get a timestamp for curent time?

Nov 20 '05 #2

Herfried K. Wagner [MVP]

* "Crirus" <Cr****@datagroup.ro> scripsit:

How to get a timestamp for curent time?

Where? In your application? In a database?

You can get the current time using 'DateTime.Now'.

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

Nov 20 '05 #3

Armin Zingler

"Crirus" <Cr****@datagroup.ro> schrieb

How to get a timestamp for curent time?

Are you looking for System.DateTime.Now? Or System.DateTime.Now.Ticks?
--
Armin

http://learn.to/quote
http://www.plig.net/nnq/nquote.html

Nov 20 '05 #4

Crirus

In my application.. found ticks and is fine, just need to convert to
seconds...I dont need smaller precision than second
"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

* "Crirus" <Cr****@datagroup.ro> scripsit:
How to get a timestamp for curent time?

Where? In your application? In a database?

You can get the current time using 'DateTime.Now'.

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

Nov 20 '05 #5

Herfried K. Wagner [MVP]

* "Crirus" <Cr****@datagroup.ro> scripsit:

In my application.. found ticks and is fine, just need to convert to
seconds...I dont need smaller precision than second

You can use the 'Ticks' property to get 100 nanosecond intervals since
1. Januar 1, 00:00:00. For example:

\\\
Dim s As Long = DateTime.Now.Ticks
MsgBox("Time: " & (s * 10 ^ -9) & " seconds")
///

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

Nov 20 '05 #6

Crirus

Yes
Thanks
Crirus

"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:u3**************@TK2MSFTNGP10.phx.gbl...

* "Crirus" <Cr****@datagroup.ro> scripsit:
In my application.. found ticks and is fine, just need to convert to
seconds...I dont need smaller precision than second

You can use the 'Ticks' property to get 100 nanosecond intervals since
1. Januar 1, 00:00:00. For example:

\\\
Dim s As Long = DateTime.Now.Ticks
MsgBox("Time: " & (s * 10 ^ -9) & " seconds")
///

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

Nov 20 '05 #7

by: perplexed | last post by:

How do you convert a user inputted date to a unix timestamp before insterting it into your database? I have a form, with a textfield for a date that the user inputs in the format mm-dd-yyyy and...

PHP

Finding Last Updated with a timestamp

by: Astra | last post by:

Hi All I know an SQL Server timestamp seems to be as useful as rocking horse for show jumping, but I'm hoping you know a 'fudge' to get me round a problem or at least confirm that it isn't...

Microsoft SQL Server

Timestamp problem!

by: rong.guo | last post by:

Hello Group, I am having a really weird problem... Can anyone tell the difference between Query 1 and Query 2 below? Why Query 2 excludes '2/28/2005'? Many thanks! create table a...

Microsoft SQL Server

using timestamp (SQL Server) to maintain concurrency in ASP.NET

by: mybappy | last post by:

Hi: I am trying to use timestamp field of SQL Server to maintain concurrency. My problem is how do I store the timestamp value in my webform. The hidden field does not work as I get some cast...

ASP.NET

"Interesting" query planning for timestamp ranges in where clause?

by: Zygo Blaxell | last post by:

I have a table with a few million rows of temperature data keyed by timestamp. I want to group these rows by timestamp intervals (e.g. every 32 seconds), compute aggregate functions on the...

PostgreSQL Database

the behaviour of timestamp on postgres.

by: Prabu Subroto | last post by:

Dear my friends... I created some tables with field timestamp (datatype also timestamp). I mean, I want to have the data when each record inserted or modified in the tables. on MysQL, I just...

PostgreSQL Database

timestamp and date behaviour with '-infinity'

by: Russell Smith | last post by:

Timestamps support infinity. However if appears dates do not. When timestamps are cast to dates, there is no output. Is this an acceptable option or not? Below are a number of examples...

PostgreSQL Database

TIMESTAMP : created & modified fields ?

by: Reddog | last post by:

Hi all, I have a number of tables that I want 'timestamped' with both a modified and created 'timestamp' field. Ideally both fields should 'work if ignored' in insert and updates, thus the...

MySQL Database

Updating SQL2005 table containing timestamp column

by: Mal Ball | last post by:

I hope I have the right forum for this question. I have an existing Windows application which uses a SQL Server database and stored procedures. I am now developing a web application to use the same...

.NET Framework

Another TIMESTAMP question

by: JJ | last post by:

How do I set one field to have the updated timestamp, and another to have the created timestamp? I want to do this directly from code generated from DB Designer if possible?! JJ

MySQL Database

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Similar topics