Tags » Datetime

Dates and time

Python has a reasonably good standard library module for handing dates and times but it can be a little confusing to a beginner probably because the first code they encounter will look something like the below with very little explanation. 384 more words


Convert excel datetime text to a sort-able standard datetime string

Here are a few excel datetime strings in format like “m/d/yyyy h:mm:ss am/pm”, so the length of this string is different in different date/time:


Transact SQL - DateAdd and avoid overflow errors


Transact SQL has adequate support for Date arithmetic exposed through dateadd, datediff, etc.

Interesting yesterday I ran into a stumbling block due to a relatively high value for the interval argument. 154 more words


SQL Server datetime to int

declare @currentDateTime datetime 
declare @timeStampValue int 

set @currentDateTime = SYSDATETIME(); 
print @currentDateTime 
set @timeStampValue = DATEDIFF(second, '1970-01-01', @currentDateTime) 
print @timeStampValue

To check the result:

https://www.epochconverter.com/ 27 more words

Binding DateTime and TimeSpan to one property

As we know together, it take different properties to record what user input into DatePicker and TimePicker. DatePicker requires DateTime property, and yet TimePicker needs TimeSpan. 847 more words

Did you know…you can’t do arithmetic operations with datetime2 like with datetime?

I’m currently working on a SQL code migration from Firebird to SQL Server and I hit an error that I haven’t seen for some time. 425 more words


Filtering data on date in PowerShell

When working with large data sets, being able to effectively filter the data is essential. A common exercise where you might need filtering on date is when reading logs, and in this blog post I will show you how you can perform the typical “ 466 more words