Sparql如何制作日/月总是返回2位数字

发布于 2025-01-30 12:01:57 字数 231 浏览 3 评论 0原文

我的sparql Query中有一个日期，我想转换为日期。因此，我确实：

 BIND(CONCAT(YEAR(?dateTime), "-",MONTH(?dateTime), "-", DAY(?dateTime)) as ?date)

这部分代码有效，但返回例如2022-2-3，我希望它是2022-02-03。如果DateTime是2022-11-23，则什么都不应改变。

原文

I have a datetime in my SPARQL-query that I want to transform to a date.
Therefore I do:

 BIND(CONCAT(YEAR(?dateTime), "-",MONTH(?dateTime), "-", DAY(?dateTime)) as ?date)

This part of code works but returns for example 2022-2-3, I want it to be 2022-02-03. If the dateTime is 2022-11-23, nothing should change.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

小鸟爱天空丶 2025-02-06 12:01:57

您可以从年，月和day函数中取回整数，并用适当的零数（转弯后）它们变成字符串）：

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT * WHERE {
    BIND(2022 AS ?yearInt) # this would come from your YEAR(?dateTime) call
    BIND(2 AS ?monthInt)   # this would come from your MONTH(?dateTime) call
    BIND(13 AS ?dayInt)    # this would come from your DAY(?dateTime) call

    # convert to strings
    BIND(STR(?yearInt) AS ?year)
    BIND(STR(?monthInt) AS ?month)
    BIND(STR(?dayInt) AS ?day)

    # pad with zeros
    BIND(CONCAT("00", ?year) AS ?paddedYear)
    BIND(CONCAT("0000", ?month) AS ?paddedMonth)
    BIND(CONCAT("00", ?day) AS ?paddedDay)

    # extract the right number of digits from the padded strings
    BIND(SUBSTR(?paddedYear, STRLEN(?paddedYear)-3) AS ?fourDigitYear)
    BIND(SUBSTR(?paddedDay, STRLEN(?paddedDay)-1) AS ?twoDigitDay)
    BIND(SUBSTR(?paddedMonth, STRLEN(?paddedMonth)-1) AS ?twoDigitMonth)
    
    # put it all back together
    BIND(CONCAT(?fourDigitYear, "-", ?twoDigitMonth, "-", ?twoDigitDay) as ?date)
}

You can take the integers you get back from the YEAR, MONTH, and DAY functions and pad them with the appropriate number of zeros (after turning them into strings):

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT * WHERE {
    BIND(2022 AS ?yearInt) # this would come from your YEAR(?dateTime) call
    BIND(2 AS ?monthInt)   # this would come from your MONTH(?dateTime) call
    BIND(13 AS ?dayInt)    # this would come from your DAY(?dateTime) call

    # convert to strings
    BIND(STR(?yearInt) AS ?year)
    BIND(STR(?monthInt) AS ?month)
    BIND(STR(?dayInt) AS ?day)

    # pad with zeros
    BIND(CONCAT("00", ?year) AS ?paddedYear)
    BIND(CONCAT("0000", ?month) AS ?paddedMonth)
    BIND(CONCAT("00", ?day) AS ?paddedDay)

    # extract the right number of digits from the padded strings
    BIND(SUBSTR(?paddedYear, STRLEN(?paddedYear)-3) AS ?fourDigitYear)
    BIND(SUBSTR(?paddedDay, STRLEN(?paddedDay)-1) AS ?twoDigitDay)
    BIND(SUBSTR(?paddedMonth, STRLEN(?paddedMonth)-1) AS ?twoDigitMonth)
    
    # put it all back together
    BIND(CONCAT(?fourDigitYear, "-", ?twoDigitMonth, "-", ?twoDigitDay) as ?date)
}

回复收藏 0 原文