{"id":2047,"date":"2023-10-27T10:21:34","date_gmt":"2023-10-27T02:21:34","guid":{"rendered":"https:\/\/www.yohz.com\/blogs\/?p=2047"},"modified":"2023-10-27T10:29:15","modified_gmt":"2023-10-27T02:29:15","slug":"using-date-and-time-values-in-your-file-naming-convention","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2023\/10\/27\/using-date-and-time-values-in-your-file-naming-convention\/","title":{"rendered":"Using date and time values in your file naming convention"},"content":{"rendered":"

In SQL Image Viewer<\/a>, Access OLE Export<\/a>, and SQL Blob Export<\/a>, you can use date values in the file naming convention.<\/p>\n

In this query, we select the ID<\/strong> (integer), content<\/strong> (blob), and lastupdated<\/strong> (datetime) fields.<\/p>\n

\"\"<\/p>\n

To use the date value from the lastupdated<\/strong> field, include it in the file naming convention value.<\/p>\n

\"\"<\/p>\n

The file name then uses the default format of yyyymmdd<\/strong> to format the date value.<\/p>\n

\"\"<\/p>\n

You can also format the date value differently using date and time specifiers.\u00a0 For e.g. using <LASTUPDATE:yyyy_mm><\/strong> indicates that we only want to use the year and month elements separated by an underscore character.<\/p>\n

\"\"<\/p>\n

resulting in<\/p>\n

\"\"<\/p>\n

You can also use the time values e.g. hhnn<\/strong> indicates we want to use the hour and minute values:<\/p>\n

\"\"<\/p>\n

resulting in this:<\/p>\n

\"\"<\/p>\n

You can use both and and time values by using the appropriate specifiers.\u00a0 The thing to note is that minute specifiers use n<\/strong> or nn<\/strong>, instead of m<\/strong> or mm<\/strong>, as those are month specifiers.<\/p>\n

A list of all date and time specifiers available here<\/a> for reference.<\/p>\n

 <\/p>\n

<\/fb:like><\/div>
<\/div><\/div>","protected":false},"excerpt":{"rendered":"

In SQL Image Viewer, Access OLE Export, and SQL Blob Export, you can use date values in the file naming convention. In this query, we select the ID (integer), content (blob), and lastupdated (datetime) fields. To use the date value from the lastupdated field, include it in the file naming convention value. The file name […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[17,44,11],"tags":[18,48,12],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/2047"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=2047"}],"version-history":[{"count":1,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/2047\/revisions"}],"predecessor-version":[{"id":2056,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/2047\/revisions\/2056"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=2047"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=2047"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=2047"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}