Skip to main content

UFormat Date Formatting - Powershell

Notes


  • By default, the date-time is displayed in long-date and long-time formats for the system locale.
    When you pipe a date to cmdlets that expect string input, such as the Add-Content cmdlet, Windows PowerShell converts the DateTime object to a string before adding it to the file. The default ToString() format is short date and long time. To specify an alternate format, use the -Format or -UFormat parameters of Get-Date.
  • Here are the valid UFormat specifiers, each of which must be preceded by %, for example, Get-Date -UFormat %Y%m%d
Format specifier Meaning Example
A Day of the week - full name Monday
a Day of the week - abbreviated name Mon
B Month name - full January
b Month name - abbreviated Jan
C Century 20 for 2006
c Date and time - abbreviated Fri Jun 16 10:31:27 2006
D Date in mm/dd/yy format 06/14/06
d Day of the month - 2 digits 05
e Day of the month - digit preceded by a space <space>5
G Same as 'Y'
g Same as 'y'
H Hour in 24-hour format 17
h Same as 'b'
I Hour in 12 hour format 05
j Day of the year 1-366
k Same as 'H'
l Same as 'I' (Upper-case I) 05
M Minutes 35
m Month number 06
n newline character
p AM or PM
R Time in 24-hour format -no seconds 17:45
r Time in 12-hour format 09:15:36 AM
S Seconds 05
s Seconds elapsed since January 1, 1970 00:00:00 1150451174.95705
t Horizontal tab character
T Time in 24 hour format 17:45:52
U Same as 'W'
u Day of the week - number Monday = 1
V Week of the year 01-53
w Same as 'u'
W Week of the year 00-52
X Same as 'T'
x Date in standard format for locale 09/12/07 for English-US
Y Year in 4-digit format 2006
y Year in 2-digit format 06
Z Time zone offset from Universal Time Coordinate (UTC) -07

Comments

Popular posts from this blog

Fixing a https Cert in Windows

 I renewed a https cert today in Windows and had problems with the new Cert sticking in Windows It would add fine, without error, but would disappear when the IIS Server Certificates screen would refresh.  Open the Certificates in MMC (Local Machine) and inspecting the Web Hosting gave a clue, the new certificate was there, but with a key - the private key was missing.  Could be because the original certificate was created on a completely different machine and imported to this new server.  At any rate, a simple certutil command fixed it .  A tip I received from  SSL disappears from the certificate list on Windows server - SSL Certificates - Namecheap.com Key steps are:  Double-click the certificate and go to  Details  tab. In certificate details locate the  Serial Number  field, click on it and copy its value. Open Command Prompt, pressing  Win+R  and typing  cmd , then click  OK In the command prompt type: ...

Ever need to reset a password in Bonobo Git Server ?

So, you've forgotten your password to bonobo git. Step 1: Get access to the sqlite file, probably called something like  Bonobo.Git.Server.db, sitting in the "wwwroot\Bonobo.Git.Server\App_Data" directory. Step 2: Using another tool, generate an md5 hash of your new desired password (as far as I know, sqlite does not have md5 capability) Step 3: Back in sqlite, using SQL, update the relevant user record, something like update User set Password = UPPER( 'thenewMD5hash') where Username = 'admin' ; Step 4: That's it, you are done, log in with your newly found password.

Save Attachments in Outlook automatically

For years I have wanted something to do this, and finally found it. Worked perfectly for me in Outlook 2013  In the end it is so simple. Guide from http://www.pixelchef.net/content/rule-autosave-attachment-outlook and https://msdn.microsoft.com/en-us/library/ee814736.aspx Open the VBA IDE in Outlook. Alt-F11 will do this. Insert the following code to the Modules section. On the left side there is a tree, expand until you find Modules. Then, if there is not a Module item under Modules, create one by right clicking on Modules. Or right click and choose Insert -> Module. Now, paste the text below in the main VBA window. Close the VBA IDE. Create a Rule that calls the script. Tools -> Rules and Alerts -> New Rule... In the first screen of the new rule wizard, choose "Check messages when they arrive". In the second, you could specify certain criteria that the message must match. Tip: Try "with specific words in the message header" and ...