Tech Diary

August 22, 2017

Covert string to valid integer

select cast(coalesce(to_number('1a2'), -1) as int)
Posted by DV at August 22, 2017 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: SQL, Tech
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Total Pageviews

Search This Blog

Labels

  • AWS
  • Bitbucket
  • Data Science
  • Finance
  • Git
  • Graph data
  • ionic
  • Java
  • JBoss
  • Linux
  • MySQL
  • R
  • Recursive
  • Regular Expression
  • S3
  • Scheduling
  • SQL
  • Tech
  • Technical Analysis
  • Teradata
  • Unix
  • Web

About Me

DV
View my complete profile

Blog Archive

  • ►  2022 (1)
    • ►  March (1)
  • ►  2021 (1)
    • ►  February (1)
  • ►  2020 (2)
    • ►  March (1)
    • ►  February (1)
  • ►  2019 (29)
    • ►  August (1)
    • ►  July (1)
    • ►  June (1)
    • ►  April (5)
    • ►  March (20)
    • ►  January (1)
  • ►  2018 (84)
    • ►  December (56)
    • ►  November (27)
    • ►  June (1)
  • ▼  2017 (18)
    • ►  November (1)
    • ►  September (1)
    • ▼  August (1)
      • Covert string to valid integer
    • ►  July (3)
    • ►  May (1)
    • ►  February (9)
    • ►  January (2)
  • ►  2016 (15)
    • ►  October (2)
    • ►  September (4)
    • ►  July (6)
    • ►  June (2)
    • ►  May (1)
  • ►  2015 (3)
    • ►  July (2)
    • ►  June (1)
  • ►  2014 (20)
    • ►  September (3)
    • ►  August (8)
    • ►  July (5)
    • ►  May (3)
    • ►  April (1)

Popular Posts

  • Teradata SQL Syntax error: All expressions in a derived table must have an explicit name.
    The below statement threw this error: SQL Syntax error: All expressions in a derived table must have an explicit name. select v1.* from di...
  • Teradata SQL INDEX function
    This is equivalent to ANSI SQL POSITION function. Example: SELECT INDEX('Teradata', 'd');    Returns 5   SELECT INDEX(&#...
  • Basis Points
    1 basis point = 1/100 of a percentage. Used mainly in Finance like changes in interest rate. Example: "The Federal Open Market Commi...
  • Different types of VPN
    Different types of VPNs: 1. Site-to-Site VPN, 2. Dynamic VPN (DMVPN), 3. Client VPN, 4. SSLVPN is explained clearly in this blog. http:...
  • Treasury Stock
    When a comany buys back its own shares and doesn’t retire them, those shares are called Treasury Stock
  • Teradata sql - retrieve top and bottom 50 percentage of the records
    Top 50% ---------- select top 50 percent  * from table1 order by id asc Bottom 50% --------------- select top 50 percent  * from ta...
  • Teradata SQL Regular Expression to compare date format
    Verify if date is in format dd-MMM-yyyy select  regexp_similar(a_date,'^(([0-9])|([0-2][0-9])|([3][0-1]))\-(JAN|FEB|MAR|APR|MAY|JUN|J...
  • (no title)
    Some Teradata Warehouse Appliance 2700 facts Ref: http://www.teradata.com/brochures/teradata-data-warehouse-appliance-2700/
  • Spider - SPDR
    Stands for Standard & Poor’s Depository Receipt. It is a S&P 500 index based ETF maintained by State Street Global Advisors. Each sh...
  • Quadruple Witching
    Quadruple Witching refers to the 3rd Friday of every quarter i.e March, June, September and December. This is the trading day when: mar...
Simple theme. Powered by Blogger.