Questions tagged [current-time]
77 questions
253
votes
18 answers
iPhone: How to get current milliseconds?
What is the best way to get the current system time milliseconds?
phil
88
votes
2 answers
Getting the current date in SQL Server?
How can I get the current date in MS-SQL Server 2008 R2?
The format of the column in my database is DATETIME and dates are stored in the following format:
+++++++++++++ Vrdate ++++++++++
| |
| 2012-11-18 00:00:00.000 …
Kamran Ahmed
- 11,809
- 23
- 69
- 101
81
votes
11 answers
Comparing results with today's date?
Is there a way to use the Now() function in SQL to select values with today's date?
I was under the impression Now() would contain the time as well as date, but today's date would have the time set to 00:00:00 and therefore this would never match?
intrigued_66
- 16,082
- 51
- 118
- 189
52
votes
9 answers
how to get current datetime in SQL?
Want to get current datetime to insert into lastModifiedTime column. I am using MySQL database. My questions are:
is there a function available in SQL? or
it is implementation depended so each database has its own function for this?
what is the…
5YrsLaterDBA
- 33,370
- 43
- 136
- 210
20
votes
5 answers
how to get current/Todays date data in sql server
how to write query to get today's date data in SQL server ?
select * from tbl_name where date =
krishna mohan
- 437
- 1
- 4
- 18
16
votes
11 answers
Check if business is open using current time and an array with days as keys and hyphen-separated time ranges as values
I'm trying to calculate if the current time is within the opening hours of a restaurant.
This question has been asked a lot on Stackoverflow, but I haven't found one that can account for the problems I am having. Also, would be nice to see idea on a…
Drew Baker
- 14,154
- 15
- 58
- 97
12
votes
2 answers
How to get current unixtime on Kotlin standard library (multiplatform)
I have a Kotlin multiplatform project, and I would like to get the current unixtime in the shared code.
How do you do that in the Kotlin standard library?
Daniele B
- 19,801
- 29
- 115
- 173
7
votes
3 answers
Show current time WPF
The only way to show current time updating regularly I found is to use timer. Of course, I can implement INotifyPropertyChanged and some special property to be used on UI but this implementation AFAIK also needs Timer. For example like here. Are…
Vadim Ovchinnikov
- 13,327
- 5
- 62
- 90
6
votes
3 answers
Java randomizing String
I'm trying to generate meaningless words without using any Random() functions. I figured out that i can use current clock or mouse coordinate. And i picked to use current clock. Here is the code i wrote.
private final char[] charray =…
Jarnsida
- 63
- 7
5
votes
1 answer
Testcafe - dealing with video
I'm testing a page with an embedded video where using the console I can play, stop, and get the current playing time.
When I try to translate that to Testcafe, I get errors. Here's what I have working on the console:
var vid =…
user9518022
4
votes
2 answers
Postgres: is NOW() used in more places of the query guaranteed to be always the same?
i was writing a query where you have tickets in a table. The column first_use_on represents the TIMESTAMP of the first time it has been used. first_use_on is by the default NULL and then updated once used the first time only. My query works fine but…
91DarioDev
- 1,612
- 1
- 14
- 31
4
votes
1 answer
why is time rising for more than one request to asyncio server in python?
I wrote a pythonic server with socket. that should receives requests at the same time(parallel) and respond them parallel.
When i send more than one request to it, the time of answering increase more than i expected.
server:
import datetime
import…
mahshid.r
- 302
- 4
- 16
4
votes
2 answers
sqlite: how to select current_timestamp as millisecond value since 1/1/1970
sqlite> select typeof(date('now'));
text
sqlite> select typeof(current_time);
text
sqlite> select typeof(current_date);
text
How to select the current date/time as an integer value of milliseconds since Jan/1/1970?
eastwater
- 4,624
- 9
- 49
- 118
3
votes
1 answer
How to set default value to CURRENT_TIMESTAMP in JPA?
I have created an entity and I want to give createdDate variable, the CURRENT_TIMESTAMP default value, how can I do that?
@Column(name = "created_date")
private LocalDateTime createdDate;
expelliarmus
- 39
- 4
3
votes
2 answers
getting the current timestamp of each row of dataframe using Spark / Java
I want to get the current timestamp of each row.
I use the following code
dataframe.withColumn("current_date",current_timestamp());
But current_timestamp() is evaluated prior to serialisation so I will always get same date.
How can I evaluate…
HBoulmi
- 333
- 5
- 16