Super User
Super User

Questions tagged [date]

For questions concerned with obtaining, manipulating or presenting the calendar date.

528 questions
81
votes
11 answers

How to set current time on Linux?

Why is the output of the following commands different? root@vmi2115:/var# hwclock Sun 26 Jun 2011 01:21:38 PM CEST -0.273230 seconds root@vmi2495:/var# date Sun Jun 26 15:21:39 CEST 2011 root@vmi2115:/var# And can I change the current time on…
dail
68
votes
22 answers

Unable to get Excel to recognise date in column

I constantly have problems working with dates in Excel, I must be doing something wrong but I don't understand what. I have a spreadsheet, exported from our exchange server, that contains a column with dates on. They have come out in US format even…
Patrick
  • 1,568
50
votes
8 answers

Store the output of date and watch command to a file

I am a newbie to linux and I am trying to watch a command and try to log it into a file. I tried watch -t -n 10 "(date '+TIME:%H:%M:%S' ; ps aux | grep "pattern" | wc -l)" >> logfile and am expecting a result like TIME: 10:32:30 12 TIME:…
LoudKur
  • 653
42
votes
4 answers

How do I parse a nonstandard date format in Excel?

I have a column of date-like string values in the format yyyy-mm-dd, such as 2011-Sep-13. I need to convert these to Excel date serial numbers so that I can use them in formulas. DATEVALUE isn't able to recognize this format; I just get #VALUE!…
Craig Walker
  • 809
41
votes
4 answers

How to display Unix time in the timestamp format?

I'm looking for a way to display my time in Debian Linux as a timestamp, e.g. 1279628325 I can't find any options to do that with the date command. Any ideas?
user32433
  • 467
35
votes
3 answers

How to insert the date into vim

In vim you can execute comands with "!". You can combine that with "r" to insert the output into your current buffer. :r!date Fri Jul 20 09:39:26 SAST 2012 will insert the date into a file. Now when I try to do some more interesting stuff…
nelaaro
  • 14,139
  • 30
  • 88
  • 115
35
votes
8 answers

Timezone conversion by command line

I know about http://www.timeanddate.com/worldclock/converter.html I can't figure out how to query http://www.google.com in a sane natural format like "5pm BST in PST". Or do I have to write such an app?
hendry
  • 1,884
31
votes
9 answers

Windows 7 - display date using small icons

I recently upgraded to Windows 7 and need the date displayed with the time. This works, but only if I use large icons in the taskbar settings which is quite ugly. How do I display the time and date when only using small taskbar icons?
kirakat
  • 331
31
votes
8 answers

How to add month to date in LibreOffice calc

This seems like an obvious question. I have a date column, and I want to create a formula to increase it by one month for each column. 10/2013, 11/2013, 12/2013, 1/2014, 2/2014, ... How do you add one month to a date?
trimbletodd
  • 509
30
votes
3 answers

How do I pipe output to date -d "value"?

I have a date like 2014-01-30 05:04:27 GMT, and if I run date -d "2014-01-30 05:04:27 GMT", the output is in my server's timezone (Thu Jan 30 16:04:27 EST 2014). With the use of grep and cut, I have extracted the date in GMT from a file. However, I…
LeigerGaming
  • 400
30
votes
3 answers

how to add a day to date in bash?

For example, I have date: 4 August 1993 and I want to add 348 days to it, how can I do it in bash?
inothemo
  • 2,289
29
votes
3 answers

Why are Excel weekdays wrong for 1900?

This question is based on the observations of AdamV in his answer on How do I get the day name into a cell in Excel? When A1 has the value 2009-08-01, then: =WEEKDAY(A1) will obtain 7 =TEXT(7, "dddd") will obtain Saturday =TEXT(7,"dddd,…
Jeroen Wiert Pluimers
  • 3,003
26
votes
9 answers

How to get the date in a batch file in a predictable format?

In a batch file I need to extract a month, day, year from the date command. So I used the following, which essentially parses the Date command to extract its sub strings into a variable: set Day=%Date:~3,2% set Mth=%Date:~0,2% set…
AngryHacker
  • 19,327
19
votes
12 answers

Windows 7 system tray date display not appearing

I'm using Windows 7 RC and for some reason, the date won't show at all on my system tray. It used to for a while, but one day it just stopped (I didn't even notice it until someone pointed it out). So I've been trying to fix it, by customizing the…
Anton
  • 293
19
votes
2 answers

Excel week number inconsistent results

I am using a spreadsheet that includes the week number for a particular date. After some research, I found a function ISOWEEKNUM() that I could apply to a column of dates and this appeared to work fine. An excerpt from this spreadsheet is shown in…
WPDavid
  • 193
1
2 3
…
35 36